Dear all, A bit background about this: I have newly incoming data from data vendor every week, and I would like to do either insert or update to my current database. If lookup matched some value (such as companyid, fiscal_year, ...etc,. )in a record then we update some value(annoucement date), otherwise insert. My lookup service setup: (Company ID) (Fiscal Year): My data is like this: Before lookup: After lookup company ID (it return fs_ID): After lookup fiscal year (it return fs_ID): And I go to Mysql database to check fs_ID = 351225894: IT DOES NOT MATCH THE COMPANY_ID (but it matched Fiscal_year)!!!!! It seems like each lookup processor working independently. My expected output it should does this: ent_fundamental.Company_ID = myincomingdata.company_ID AND ent_fundamental.Fiscal_year = myincomingdata.Fiscal_year etc., (then it will return me a fs_ID so that I can update this record) Or Does anyone have any good idea to do a multiple columns lookup in NIFI?
... View more
