From the error message it looks like lookup("TABLE_NAME", "FIELD_NAME": [DATAPILL2]) this returns null(blank) value1. Make sure that you have data for lookup("TABLE_NAME", "FIELD_NAME": [DATAPILL2])OR2. Add the quotes and contact before and after loo...
If you want to Archieved the lookup data... Keep regulary (Weekly / mothly / quaterly / yearly) backup of Lookup data to external storage... like AWS S3 or on primised MySql database etc.To do this backup process, a) you can do it either manually...
1. If you would retain data across different Jobs.. you need to use external storage(e.g. AWS S3 / MySql etc.) 2. In case of cache and use large data within a single Job executinon...- You can use Collection (First, prepare the list of raw data and t...