I'm trying to get three files to combine into one MapInfo file. The three files have a unique identifier amongst them. The Excel spreadsheet has the data and the two ESRI shapefiles geometry. I'm trying to combine the three files into one MapInfo file. It seems like I should be able to tell FME to combine into MapInfo based on the unique identifier. I've failed with both Joiner and FeatureMerger. Any suggestions on different transformers or how better to use either of the transformers I mentioned?
Page 1 / 1
Hi,
My take on this would be:
- Read shp's
- Use aggregator with a group by (ID) > resultst in geometry aggregates of the same ID
- Use joiner to add XLS data
- Write to mapinfo
Look out for keeping the extra attributes in the aggregator (setting in transformer).
Hope this helps,
Itay
Hi,
You can use either the Joiner or the FeatureMerger, you are pointing to the right direction. If you will use the Joiner, take a look at Itay's suggestion.
If you also will try using the FeatureMerger:
1) Send features from the Shape reader to REQUESTOR port.
* Aggregate beforehand if necessary, as Itay mentioned.
2) Send features from the Excel reader to SUPPLIER port.
3) Set "Join On" parameter.
Requester <-- ID attribute name of Shape features
Supplier <-- ID attribute name of Excel features
Every output Shape feature from MERGED port will have Excel attributes matching on ID.
Takashi