Hi,
I have this data below which I would like to transform into a single record per row.key. How do I do it?
Ideal output would be 2 records with field.name converted to columns.
Cheers
Solved
Merge records into single row per key
Best answer by ebygomm
I would typically create a new attribute using the field.name value and set it to the value of field for each record. Then expose these attributes and then aggregate based on row.key. This assumes you know all possible field.names to expose
e.g.
+32- Influencer
- Best Answer
I would typically create a new attribute using the field.name value and set it to the value of field for each record. Then expose these attributes and then aggregate based on row.key. This assumes you know all possible field.names to expose
e.g.
+17- Contributor
ebygomm wrote:
I would typically create a new attribute using the field.name value and set it to the value of field for each record. Then expose these attributes and then aggregate based on row.key. This assumes you know all possible field.names to expose
e.g.
ebygomm wrote:
I would typically create a new attribute using the field.name value and set it to the value of field for each record. Then expose these attributes and then aggregate based on row.key. This assumes you know all possible field.names to expose
e.g.
In relation to this one, Given the xml below
I get this after XML Fragmenter
Is there a way that after it goes through the aggregator it concatenates the field.name "GIVEN_NAMES" into a single column? Or is it better to edit the XML and change one of the "GIVEN_NAMES" into say "FIRST_NAME" so I could exppose them separately?
Right now, I am getting this one below after AttributeExposer and just ignores the 2nd Given Name after going through Aggregator.
TIA
ebygomm wrote:
I would typically create a new attribute using the field.name value and set it to the value of field for each record. Then expose these attributes and then aggregate based on row.key. This assumes you know all possible field.names to expose
e.g.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.