topic Re: Add a column to a table in QlikView

Add a column to a table

Wed, 10 Jul 2013 09:49:47 GMT

Hi !

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)

LOAD

ID,

weight

RESIDENT Table2;

Thank you for your help.

swuehl — Wed, 10 Jul 2013 09:55:32 GMT

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.

Gysbert_Wassenaar — Wed, 10 Jul 2013 09:57:02 GMT

Perhaps you need to use the distinct keyword:

INNER JOIN (Table1)

LOAD DISTINCT

ID,

weight

RESIDENT Table2;

er_mohit — Wed, 10 Jul 2013 09:58:01 GMT

see attached file

here

i think the valuein your name and date field having null for some ID

therfore it showing you