Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
What is the use of flag?