Concatenate

[manoranjan_d]

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 ?

[Kushal_Chawda]

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

[ankit777]

Hi

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.

[manoranjan_d]

thanks

[santiago_respane]

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,