I need to take serial tabular data and join or pivot it to columns joined on the common field UniqueID. I've been reviewing joins and mergers but cannot determine how to create this transformation.
The resulting data columns should be UniqueID, longitude, latitude, Cat1,...Cat9
Thank you,
Gilbert
Create new attributes from the parameter names and set their value to value
Expose the newly created attributes
Aggregate on Group ID, merging incoming attributes
Remove parameter_name and value attribute
Thank you. It works but I still don't understand the process. I will study it further. Thank you!