Skip to main content
Question

Serial tabular data to parallel Join


gcarmich
Participant
Forum|alt.badge.img+1

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

 

imageThank you,

Gilbert

2 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • May 23, 2023

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

image 


gcarmich
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • May 23, 2023

Thank you. It works but I still don't understand the process. I will study it further. Thank you!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings