Dear all, A bit background about this: I receive fresh data from a data vendor on a weekly basis and aim to either insert or update my existing database. If the lookup identifies matching values (such as company ID, fiscal year, etc.) in a record, we perform an update on specific fields (e.g., announcement date); otherwise, we insert a new record. My chain of lookups: My lookup processor setup: My data: Before lookup: After first lookup (Company ID) (It return me fs_ID): After second lookup (Fiscal_Year) (It return me another fs_ID): Note: fs_ID is retrived value from lookup tables However, I check my lookup table: It does not match the "Company_ID", it only match the "Fiscal_year", It seems like those lookup processor worked independently. I expected this output: myincomingdata.Company_ID = ent_fundamentals.Company_ID AND myincomingdata.Fiscal_year = ent_fundamentals.Fiscal_year..etc., (I can update this record base on those columns if they all match) Can anyone please help me this issue or is there any other way in doing lookup inNIFI?
... View more
