topic Re: Union Concept in Qlikview Load script in QlikView

Union Concept in Qlikview Load script

Tue, 14 Oct 2014 08:44:13 GMT

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

Re: Union Concept in Qlikview Load script

vardhancse — Tue, 14 Oct 2014 08:49:02 GMT

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

Table_1:

Load A,

from ABC;

Left join(Table_1)

Load A,

from BCD;

similarly table_3.

Then at last we can get only one table.

Re: Union Concept in Qlikview Load script

Tue, 14 Oct 2014 08:49:15 GMT

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;

Re: Union Concept in Qlikview Load script

CELAMBARASAN — Tue, 14 Oct 2014 08:51:41 GMT

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

Re: Union Concept in Qlikview Load script

Tue, 14 Oct 2014 08:59:05 GMT

Hi Shruthi Reddy & Celambarasan ,

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

Best,

Robert