Skip to main content
Question

FME Desktop 2020: How to map excel table using “schema mapper”?

  • November 12, 2021
  • 3 replies
  • 69 views

jamal
Forum|alt.badge.img+5

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

 

Clip_1103 

 

 

 

 

 

 

 

 

 

 

 

3 replies

muzhnasto
Contributor
Forum|alt.badge.img+12
  • Contributor
  • November 12, 2021

Hi @jamal​ , use FeatureMerger, I think it will help you


jamal
Forum|alt.badge.img+5
  • Author
  • November 16, 2021

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

 

Clip_1138 

Clip_1139 

 

 

 

 

 

 

 


jamal
Forum|alt.badge.img+5
  • Author
  • November 16, 2021

The data is attached with correct configuration


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings