Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below table
Name | 3-support | onemore |
a | table2-support3 | er |
n | e | rt |
c | y | ty |
d | no | |
d | oh |
I want to merge the rows based on the Name for e.g.
The last 2 rows should be merged in one row as
d oh no
Can someone please help understand how I can accomplish this? I tried doing a self join but that didn't get me the results I want. Thanks in advance for your help.
Thanks,
Samira
Going back to the example you used for the solution, you did a load inline for source table. I am not doing a load inline but instead am loading from a spreadsheet. And during the load I am doing a if(match) to get data into separate columns. so based on your solution, if I drop the source table at the end, won't I lose the new columns that I am creating during my initial load of the source table?
Sorry if this is getting complicated. I will start a new discussing but it will be an extension of this post.Thanks for all your help.
Thanks,
Samira