Concatenation

[risabhroy_03]

I have two tables [Stage 1] and [Stage 2].

I have to concatenate [Stage 2] to [Stage 1], I wrote the following commands but in the result, the values from [Stage 2] is not showing.

First I wrote this 

Concatenate ([Stage 1])

[Stage 3]:
Load *
Resident [Stage 2];

Drop table [Stage 2];

After that i wrote this

[Stage 1]:
Load *
Resident [Stage 1];
Concatenate ([Stage 1])
Load *
Resident [Stage 2];

Drop table [Stage 2];

But in both cases, I am just getting from the stage 1 and stage 2 values are missing, but when I run them separately it works fine.

Plzz help.

[PrashantSangle]

To investigate more add flag field while concatenate then check

like,

[Stage 1]:
Load *,

'Stage 1' as Flag
Resident [Stage 1];
Concatenate ([Stage 1])
Load *,

'Stage 2' as Flag
Resident [Stage 2];

Drop table [Stage 2];

Regards,

Prashant Sangle

[risabhroy_03]

What is the use of flag?