FME Desktop 2020: How to map excel table using “schema mapper”?
I couldn’t figure out how to link the attribute table of a layer with an excel table.
In the screenshot below, I wanted to link the attribute layer with an excel table based on the autocad_color and ColorNo fields in order to get the “type” field values transferred to the layer.
How could be performed?
The data is attached
Hi @jamal , use FeatureMerger, I think it will help you
I got a help from a colleague. Quite easy! All what I need is to add two more fields to the excel table and then to configure the schema mapper correctly as per the screenshot below
The data is attached
The data is attached with correct configuration
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.