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?
