Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner
Partner

Concatenation

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.

2 Replies
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

Great dreamer's dreams never fulfilled, they are always transcended.
risabhroy_03
Partner
Partner
Author

What is the use of flag?