Skip to main content
Question

create attributes from a table

  • Jun 15, 2022 4:48 PM UTC
  • 2 replies
  • 107 views

alc33
Contributor
Forum|alt.badge.img+14

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+36
  • Influencer
  • Jun 15, 2022 5:17 PM UTC

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+14
  • Author
  • Contributor
  • Jun 16, 2022 3:40 PM UTC

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