Skip to main content
Question

1st row as Column


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+39
  • Influencer
  • 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+35

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
  • June 1, 2022
j.botterill wrote:

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
  • June 1, 2022

now its coming like this

image


j.botterill
Influencer
Forum|alt.badge.img+39
  • Influencer
  • 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+35
asadamjad wrote:

now its coming like this

image

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

 


Reply


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