Skip to main content
  • EN

Hello FME users,

I have two spreadsheet one of them contains phone log information and the other one has caller details with their phone number, attached herewith. I want to merge them into one if their phone number matches. The Phone number is common column between two spreadsheets. Please advise.

The FeatureMerger is probably what you'll want to use. An overview of this transformer can be found in the FME Desktop Basic training course

http://desktopmanualbasic.safe.com/DesktopBasic5Transformers/5.Exercise3.html

This might also be helpful

Data Joins

The FeatureMerger is probably what you'll want to use. An overview of this transformer can be found in the FME Desktop Basic training course

http://desktopmanualbasic.safe.com/DesktopBasic5Transformers/5.Exercise3.html

This might also be helpful

Data Joins

Also check out the Joiner transformer -- you'd read one of the sheets via a normal FME reader and pipe it into the Joiner, and then in the Joiner, configure for the other sheet.

Also check out the Joiner transformer -- you'd read one of the sheets via a normal FME reader and pipe it into the Joiner, and then in the Joiner, configure for the other sheet.

I tried Joiner but the results I am getting is not as per my expectations. Maybe I am not configuring accordingly. I want a new spreadsheet with all attributes with both matched phone numbers. Thanks

Reply


Community Stats

30,122
Posts
114,332
Replies
37,750
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.