Skip to main content
  • EN

Hello,

I've got an Excel sheet like the following and I simply like to map an Attribute in my FME workbench.

My workbench looks like:

And my AttributeValueMapper Parameters are:

In my example the value in FEATURE (AttributeCreator) is inside of the Excel sheet but as result I always get the standard value, not the value I'd like to be mapped.

In Excel the cells are formated as text since there are also alphanumerical values.

Hope someone may help here.

btw: How do I prevent the file upload here to add the path of my files to the filename as prefix?

don't exactly understand your issue but if you are looking for a way to introduce the values from the excel into the value mapper use the import button on the bottom

Hi @maikhertel, you have to define value mapping rules in the parameters dialog, like this.

As Itay mentioned, you can import the values from the Excel table using the 'Import' button function.
Alternatively, in this case, you can read the Excel table with the Excel reader and use the FeatureMerger to merge a record to each feature using the 'Feature' value as join key.

Okay I see my mistake, I have chosen attribute names instead of attribute values during the Import dialogue. So just my first row was imported and I thought that's it. So that's not a dynamic way of mapping, if Excel changes I need to reimport. The FeatureMerger @takashi mentioned will be my option.

Thank you!

Reply


Community Stats

30,122
Posts
114,333
Replies
37,751
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.