I would like to add a column with values to an existing table in Qlikview, with no KeyValues between them.

[krishna789]

I would like to add a column with values to an existing table in Qlikview, with no KeyValues between them.

These are the columns of table 1

Column1 | Column2|

1           Q

2           Z

3           T

This is the column I want to append from table2, to table 1

Column3|

ret

ret

ret

This is how it should look like after appending

Column1 | Column2| Column3 |

1           Q       ret

2           Z       ret

3           T       ret

[sunny_talwar]

Is Column3 always have the same value? If it is, then you can do this

Table:

LOAD Column1,

           Column2

FROM ... Table1;

Left Join (Table)

LOAD DISTINCT Column3

FROM Table2;

[aapurva09]

Hi Krishna,

If there is no key between the 2 tables, you can directly join them using JOIN keyword, but doing this can replicate the data if there will be more than one value on Column 3.

[yoganantha321]

Hi krishna,

As sunny response joining the table is the best way to get the above output