I need Help in the script writing related. In order to achieve my goal , I need to do the below process -
1.Load a table named associate_table into Qlikview INDX.
2. Add to National_ID to the associate table.
In Both table EMPL_ID is the common column.
Here National ID is coming from another table say national_table. The new table should have national_ID column with all the columns from associate table. Need your suggestion on achieving this Please find attached Data sample in the excel sheet.
Any help will be highly appreciated.
Thank You !