Skip to main content
Solved

Fetch from the Lookup Table

  • November 30, 2017
  • 1 reply
  • 18 views
parashari
Forum|alt.badge.img+2

Hi Experts. I have an excel table 'lookup'(attached) with 2 sheets accounting and count. I want to add a column number in the count table wherein the value of number would be from the value attribute from accounting table with respect to the count attribute.

I have tried using a combination of sorter, counter, lists and aggregator but didn't get the desired results. May be I had tried somewhat other way.

Thanks.

Best answer by ebygomm

You can use a FeatureMerger here, with the Count table going into the Requestor port and the accounting table going into the Supplier and choosing the relevant columns (count/accounting) to merge on

1 Attachments
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

ebygomm
Influencer
Forum|alt.badge.img+46
  • ebygommInfluencer
  • Influencer
  • Best Answer
  • November 30, 2017

You can use a FeatureMerger here, with the Count table going into the Requestor port and the accounting table going into the Supplier and choosing the relevant columns (count/accounting) to merge on

Community Stats

32,154
Posts
122,048
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.