Merge Rows with shared ID and only one distinct value per Column

[holymosfet]

Hi all,

I feel like this must be a beginner question but I couldn't find out how to solve it. I have the left table and want to transform it to the right table:

 Is there any easy way to do it?

Thank you!

[Anonymous]

Hello Holy.

This can be achieved with left Join in load script..Am unable to write it for you as am on mobile..My bad..

[MayilVahanan · Accepted solution]

HI @holymosfet 

If you have one values for A,B,C,D for ID. then try like below

Load ID, Min(A), Min(B), Min(C), Min(D) from yoursource group by ID;

[Millerien]

Thanks for the update and quick reply. I'll be sure to keep an eye on this thread.

[holymosfet · Accepted solution]

Hi Mayil,

thanks a lot it worked! I just had to add the AS statements:

Load ID, Min(A) AS A, Min(B) AS B, Min(C) AS C, Min(D) AS D from yoursource group by ID;