Skip to main content
Question

create attributes from a table


alc33
Contributor
Forum|alt.badge.img+10
  • Contributor

hi!

I have an excel file with 2 colums :

on A : the name of the attributes

on B : the values

I don't succeed to create the attributes on FME and to associate the values.

I tried with ListBuilder, Exploder, Aggregator, but I don't succeed.

Can you help me?

Thanks !

2 replies

dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • June 15, 2022

I think the easiest method would be to use a SchemaMapper. In the SchemaMapper you will point it to your excel file as source (you will need to change format to Excel). Then in the next parameter screen, click the + sign and choose New Attribute. Your parameters for that will look like this:imageClick Finish, then feed the Mapped port into a Sampler to select only one feature (you will have multiple features with the schema otherwise.

imageWorkbench will look like this:image


alc33
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • June 16, 2022

@dustin​ Thanks for your answer! I will try that!


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