Hi There!
I need to add a specific field in the lookup and keeping the all old data as it is,
I'm having lookup1_kvstore , which consists of several fields and check_date as well
also lookup2.csv consists of check_date, src_name , I need to update check_date from lookup2.csv to lookup1_kvstore and keeping all the old fields as it is except check_date.
Thanks in Advance!
Assuming src_name exists in both lookups, try something like this
| inputlookup lookup1_kvstore
| lookup lookup2.csv src_name OUTPUT check_date
| outputlookup lookup1_kvstore