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.
![jarviszzzz_0-1706164037221.png jarviszzzz_0-1706164037221.png](https://community.cloudera.com/t5/image/serverpage/image-id/39560iB0EF88104F17EFD7/image-size/medium?v=v2&px=400)
My lookup service setup:
(Company ID)
![jarviszzzz_1-1706163492807.png jarviszzzz_1-1706163492807.png](https://community.cloudera.com/t5/image/serverpage/image-id/39550i878F3FF313325C32/image-size/medium?v=v2&px=400)
![jarviszzzz_2-1706163515500.png jarviszzzz_2-1706163515500.png](https://community.cloudera.com/t5/image/serverpage/image-id/39551i4F5ECAA4833FC479/image-size/medium?v=v2&px=400)
(Fiscal Year):
![jarviszzzz_3-1706163540383.png jarviszzzz_3-1706163540383.png](https://community.cloudera.com/t5/image/serverpage/image-id/39552i05EE36CDFFD9F563/image-size/medium?v=v2&px=400)
![jarviszzzz_4-1706163556336.png jarviszzzz_4-1706163556336.png](https://community.cloudera.com/t5/image/serverpage/image-id/39553i40B1C106EFCD4BC3/image-size/medium?v=v2&px=400)
My data is like this:
Before lookup:
![jarviszzzz_5-1706163595810.png jarviszzzz_5-1706163595810.png](https://community.cloudera.com/t5/image/serverpage/image-id/39554i302369004EB8EBB3/image-size/medium?v=v2&px=400)
After lookup company ID (it return fs_ID):
![jarviszzzz_6-1706163639762.png jarviszzzz_6-1706163639762.png](https://community.cloudera.com/t5/image/serverpage/image-id/39555i45B76E9957CE1B95/image-size/medium?v=v2&px=400)
After lookup fiscal year (it return fs_ID):
![jarviszzzz_8-1706163698123.png jarviszzzz_8-1706163698123.png](https://community.cloudera.com/t5/image/serverpage/image-id/39557i3AFA3C354AA72483/image-size/medium?v=v2&px=400)
And I go to Mysql database to check fs_ID = 351225894:
![jarviszzzz_10-1706163768502.png jarviszzzz_10-1706163768502.png](https://community.cloudera.com/t5/image/serverpage/image-id/39559i7DDEAF7C609A83AF/image-size/medium?v=v2&px=400)
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?