Question

1st row as Column


Badge +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

Userlevel 2
Badge +19

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

Userlevel 4
Badge +26

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

 

Badge +5

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

Badge +5

now its coming like this

image

Userlevel 2
Badge +19

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

Userlevel 4
Badge +26

now its coming like this

image

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

 

Reply