Hi,
In my project my requirement is merge the duplicate values into one.
My source is like this:
key,col1,col2,col3,col4
01, a, null, null, null
01, null, b, null, null
01, null, null, c, null
01, null, null, null, d
02, p, null, null, null
02, null, q, null ,null
02, null ,null ,r, null
02, z, null ,null ,s
But I wants my target is like this:
key,col1,col2,col3,col4
01,a,b,c,d
02,z,q,r,s
based on key column we can merge the column values.
Please help me to achieve this logic.
I'm struggling to get this output.
Thanks,
merge duplicate values
Moderators: chulett, rschirm, roy