Hi,
I want to combine data in column Asset into one record
Eg heres my input data :
Code | Name | Ccy | Asset |
280 | Alex | EUR | Govt-Spain |
280 | Alex | EUR | Govt-Italy |
290 | Peter | GBP | Cash-EUR |
302 | Keith | USD | Cash-EUR |
438 | Adam | INR | Govt-United States |
438 | Adam | INR | Govt-United States |
My expected output creates a unique row for each code
Expected output :
Code | Name | Ccy | Asset |
280 | Alex | EUR | Govt-Spain, Govt-Italy |
290 | Peter | GBP | Cash-EUR |
302 | Keith | USD | Cash-EUR |
438 | Adam | INR | Govt-United States, Govt-United States |
Is this possible?
@clarrock Use the summarize tool group by code, name and city, for the asset field select string - concat option
hi @clarrock
You can use Summarize tool like this. By the way, your sample data has duplicated records (row5&6). If you need to remove the duplicated row, put Unique tool before Summarize tool, if this better fits to your case.