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.