Removing white spaces and adding rows

I have come across an issue as per the image where I have to remove all duplicate rows and make one row removing white spaces in the last three columns into one rows. Take a loot at the image and help me to get this sorted.

Hello @psycho,

from your example you should be able to do it using GroupBy node. Grouping columns are ones which identify your project and aggregate on source columns with aggregation type First. Make sure to un-check Missing option.


1 Like

It worked. Thank you very much.


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.