loading tables

[Anonymous]

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?

[marcus_sommer]

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

[Anonymous]

Hi Sanju,

Why would you want to do so?

[miguelbraga · Accepted solution]

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,

MB