Union Concept in Qlikview Load script

[#1]

Hi,

Source_Status:

// Load the Satus1

LOAD id_soi,

     order_nr,

     created_date,

     item_status,

     order_status

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

// Load the Satus2

LOAD id_soi,

     order_nr,

     created_date,

     item_status,

     order_status

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

// Load the Status3

LOAD

     id_soi,

     order_number as order_nr,

     created_date,

     item_status,

     order_status

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Above is my Load script, I have same attribute but in three different table. Now I want merge them into one table then  i have remove the id_soi duplicate value.

I tried something below like but it doesn't work.

Status:

LOAD

    Distinct  id_soi,

     order_nr,

     created_date,

     item_status,

     order_status

RESIDENT Source_Status;

could you please advise me

Best

Robert

[vardhancse]

if we want to join all those 3 tables based on one common field, we can

Table_1:

Load A,

B

from ABC;

Left join(Table_1)

Load A,

C

from BCD;

similarly table_3.

Then at last we can get only one table.

[#3]

Hi,

Since your source table structure is same as source_status, it will concatenate the Source table to Source_status,

you can add a dummy field in Status table to avoid this.

Status:

LOAD

    Distinct  id_soi,

     order_nr,

     created_date,

     item_status,

     order_status,

'dummy' as flag

RESIDENT Source_Status;

drop table Source_Status;

drop field flag;

[CELAMBARASAN · Accepted solution]

Hi,

Use NoConcatenate, when Qlikview sees the same table structure which is previously loaded it concatenates automatically to existing one.

Status:

NoConcatenate

LOAD

    Distinct  id_soi,

     order_nr,

     created_date,

     item_status,

     order_status

RESIDENT Source_Status;

Drop Table Source_Status; //Drop the Source table

[#5]

Hi Shruthi Reddy & Celambarasan ,

Thank your prompt reply  ... Both answer works fine.

Best,

Robert