Hi!

So when you want to edit a lookup file, you would need to re-run the plan where that lookup file builder is contained.

So for example, if you have 10 rows in the lookup, and you want to append 2 more, you would have to have all 12 rows in your file that will be used to create the lookup (it would be your existing rows + new rows). If its just that you want to edit a value in one or two rows for example, you would just take that same file you used to create the lookup in the lookup builder step, open that file as a text file, make the change, and then re-run the plan so the lookup can be recreated.

Please note that everytime you run the lookup builder step, it does a full refresh of the data, meaning it deletes everything and then reloads the data with the contents of the new file used in this. so if you want to append data, I reccomend taking the file you used to create the lookup, add in the x new rows you want in the lookup, and then re-run the plan with the new saved input-data file. If you want to just edit a row or column, open the existing input-data text file with text editor, make the changes to the data, save, and then re-run the plan, you will see the changes made in your new .lkp file.

When trying to open a .lkp file, it will show unreadable characters, so whenever making a change to the data within a lookup, you have to do it at the source file and the lookup step for any configuration changes

Hope this helps!!

Additional tip: If you’ve lost your original source data, and only have the current .lkp file, you can use the Lookup Reader step to turn it back into plain text.

Then you can add to the data and turn it back into a .lkp using a Lookup Builder step.

@Samuel Muvdi and @may_kwok : Thank You so much for your inputs. I have created a csv file in files → data → ext → src and then created a plan in files → data → ext → build to populate .lkp file in files → data → ext → lkp

Once plan is created i did right click on name and then Run Plan. It gave message that task got completed successfully. Is that the only step to load source data in lkp file because after task completion I am not able to see the updated data in lkp file. Am I missing something? Sorry for being very naive but I dont even have a training experience on Ataccama :(

@Samuel Muvdi and @may_kwok : Same steps has worked today. Thanks for all your help