topic Re: Concatenate in QlikView

Concatenate

manoranjan_d — Tue, 17 May 2016 11:25:54 GMT

Table1:

load*from xxx1.qvd

Table2:

load*

X as flag;

resident Table1;

load*

Y as flag;

resident Table1;

concatenate(table1)

load * from xxxx2.qvd

I having doubt on this concatenate i have applied the concatenate(table1) so only the Table 1 will be concatenated to Table2? it will omit the resident table?

the resident of X and Y flag and XXX2.qvd and Table1, all will be concatenated ?

Re: Concatenate

Kushal_Chawda — Tue, 17 May 2016 11:31:06 GMT

why you are creating X, Y flag for same Table?

Re: Concatenate

ankit777 — Tue, 17 May 2016 11:34:21 GMT

Here only Table1 will be concatenated with data from xxxx2.qvd

Table 2 will exist separately with x flag.

another table will exist with y flag.

However this will generate synthetic key in the data model.

Re: Concatenate

manoranjan_d — Tue, 17 May 2016 11:42:34 GMT

thanks

Re: Concatenate

santiago_respane — Tue, 17 May 2016 11:51:02 GMT

Hi Manoranjan,

what are you trying to achieve? why are you creating those flags? Maybe if you describe what are trying to achieve it is easier for us to help you.

According to your code you will end up with the following:

----Table1 with the concatenation of the xxx1 and xxx2 qvds

----Table2 with the concatenation of table1 with x as flag and table2 with y as flag

Table2 will only be concatenated if you force it with the concatenate command.

Let me know if this help.

Kind regards,