Skip to main content
Question

How can I transpose a column which was extracted from a json file?


mda
Contributor
Forum|alt.badge.img+7
  • Contributor

I am extracting two attributes ( Naam, Value) from a json file. The contents of the "Naam"attribute are actually attributes names and the contents of the "Value"attrbute are the values. So what I need is to transpose the "Naam" attribute to columns and fill those columns with the content of the "Value"attribute (see attachments). I have tried attributepivoter and also attribute Transposer custom transformer. Unfortunatley, I keep getting nothing useful or empy output. Could you please help me with this!

3 replies

muzhnasto
Contributor
Forum|alt.badge.img+12
  • Contributor
  • January 19, 2021

tomf
Contributor
Forum|alt.badge.img+14
  • Contributor
  • January 20, 2021
muzhnasto wrote:

You need to follow the AttributeTransposer with an AttributeExposer in order to see the attributes in the table view of Visual Preview/Data Inspector


mda
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • January 20, 2021
tomf wrote:

You need to follow the AttributeTransposer with an AttributeExposer in order to see the attributes in the table view of Visual Preview/Data Inspector

Indeed the AttributeExposer is the key. Thanks a lot!


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