Skip to main content
Solved

Merge attributes of two excel sheets


Forum|alt.badge.img

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.

Best answer by ryanatsafe

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

View original
Did this help you find an answer to your question?

3 replies

Forum|alt.badge.img+2
  • Best Answer
  • July 27, 2016

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


fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • July 28, 2016
ryanatsafe wrote:

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.


Forum|alt.badge.img
  • Author
  • July 28, 2016
fmelizard wrote:

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


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