Discussion Board for collaboration on QlikView Scripting.
I have a table : Table1 which contains many informations like ID, date, name ... and another one : Table2 which contains the ID and the weight.
I would like to add, for each ID of the first table, the weight.
I tried with this script but it creates new rows in table1 and i don't know why. I want to keep the same number of row in table 1.
INNER JOIN (Table1)
Thank you for your help.
Go to Solution.
Perhaps you need to use the distinct keyword:
Check if your second table shows several weight values per ID (maybe only for some of the IDs).
You probably should clean your data first then use a join or a MAPPING approach.
see attached file
i think the valuein your name and date field having null for some ID
therfore it showing you