Skip to main content
Question

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

  • January 19, 2021
  • 3 replies
  • 94 views

mda
Contributor
Forum|alt.badge.img+7

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
Supporter
Forum|alt.badge.img+20
  • Supporter
  • January 20, 2021

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

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!