Skip to main content
Question

create attributes from a table

  • June 15, 2022
  • 2 replies
  • 50 views

alc33
Contributor
Forum|alt.badge.img+11
  • Contributor
  • 54 replies

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
  • 627 replies
  • 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+11
  • Author
  • Contributor
  • 54 replies
  • June 16, 2022

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