Skip to main content

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 !

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


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


Reply