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
Best answer by ebygomm
View original
Userlevel 1
+21
- Contributor
- 3079 replies
-
24 July 2018
- 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.
Userlevel 4
+13
- Contributor
- 3725 replies
-
24 July 2018
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.
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
Userlevel 2
+17
- Contributor
- 7538 replies
-
25 July 2018
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.