How can I edit existing lookup files to add new values? File location is “files → data → ext → lkp”
or how can I create a new lkp file in same path?
How can I edit existing lookup files to add new values? File location is “files → data → ext → lkp”
or how can I create a new lkp file in same path?
Best answer by Samuel Muvdi
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!!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.