topic Re: loading tables in QlikView

loading tables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

i have 3 tables with all the columns name same. but while loading the tables only the first table gets loaded.

how to load other two tables without using qualify statement?

Re: loading tables

marcus_sommer — Mon, 05 Sep 2016 15:23:40 GMT

Tables with the same structure wille be automatically concatenated so that you get only one table which contained all records. If you really want to avoid this behaviour you could use the key-word NoConcatenate before the Load - but now you will get a lot of synthetic keys between those tables if you don't add some additionally logics.

- Marcus

Re: loading tables

Anonymous — Mon, 05 Sep 2016 15:24:23 GMT

Hi Sanju,

Why would you want to do so?

Re: loading tables

miguelbraga — Mon, 05 Sep 2016 15:25:01 GMT

Hey there,

The 3 tables will be autoconcatenated if do nothing and only upload the 3 tables. To make different result without using Qualify you must do as follow:

Table1:

LOAD A as A1,

B as B1,

C as C1

FROM [your 1st connection to your database goes here];

Table2:

LOAD A as A2,

B as B2,

C as C2

FROM [your 2nd connection to your database goes here];

Table3:

LOAD A as A3,

B as B3,

C as C3

FROM [your 3rd connection to your database goes here];

Hope this helps

Regards,