+1
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 !
+26
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:
Click Finish, then feed the Mapped port into a Sampler to select only one feature (you will have multiple features with the schema otherwise.
Workbench will look like this:
+1
@dustin Thanks for your answer! I will try that!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
