Skip to main content
Solved

Fetch from the Lookup Table

  • November 30, 2017
  • 1 reply
  • 8 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

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

1 reply

ebygomm
Influencer
Forum|alt.badge.img+39
  • 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


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