Skip to main content
Question

1st row as Column

  • May 31, 2022
  • 6 replies
  • 266 views

Forum|alt.badge.img+5

Name attribute will come in columns and value come in rows 

 

Is there any way to that

image 

Output come like this

 

image

6 replies

j.botterill
Influencer
Forum|alt.badge.img+53
  • Influencer
  • 386 replies
  • June 1, 2022

how are you reading the data in? If CSV or Excel in the reader, you can go to Parameters of the reader and for the sheet you're interested in.... change the Field Name row = 2

 

then down the bottom - change the "Attributes" Name to be timezone and CDTreaderparameters FieldNames rowOther tips:

Expose the reader format types and introduce TestFilters for processing certain row = 2 etc. Also utilising attributetransposer/exploder transformers


virtualcitymatt
Celebrity
Forum|alt.badge.img+47

You need to use the AttributeCreator and you can set the following settings

 

image 

This will not 'expose' the attributes though for use or for the output schema so you need to follow it with an AttributeExposer

 


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • June 1, 2022

how are you reading the data in? If CSV or Excel in the reader, you can go to Parameters of the reader and for the sheet you're interested in.... change the Field Name row = 2

 

then down the bottom - change the "Attributes" Name to be timezone and CDTreaderparameters FieldNames rowOther tips:

Expose the reader format types and introduce TestFilters for processing certain row = 2 etc. Also utilising attributetransposer/exploder transformers

No i m using KMZ file


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • June 1, 2022

now its coming like this

image


j.botterill
Influencer
Forum|alt.badge.img+53
  • Influencer
  • 386 replies
  • June 2, 2022

perhaps you can run the workspace to the last transformer

then go File > Save as template and tick to include the feature cache

Reply to this and attach the .fmwt


virtualcitymatt
Celebrity
Forum|alt.badge.img+47

now its coming like this

image

Oh yeah, right - you need to run it through an Aggregator to squish then into one feature