Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Sagar082
Creator
Creator

Joining of table with previously concatenate table

Hi Folks,

Greeting for the day. I have three tables; table 1, table 2 and table 3. In which table 1 and table 2 have master data hence need to concatenate whereas table 3 is data from system. So, I need to join table 3 with previously concatenate table.

I use the following script;

master:

load * from table 2;

concatenate

load *

from table 2;

right join(Master)

final table:

load * from table 3;

Even though the data is completely loaded, the final table joins with Master table, which consequently result into change of the table name to master table and master table columns are consider at the beginning.

Where as I am looking after joining the table name should be final table and final tables column should be first in the sequence and followed by Master tables columns.

Can you please figure out where, I'm committing mistakes.

Regards,

Sagar. 

3 Replies
Kushal_Chawda

@Sagar082  try below

master:

load * from table 1;

concatenate

load *

from table 2;

final:

load * from table 3;

left join(final)

load *

resident master;

drop table master;

Sagar082
Creator
Creator
Author

Hi Kush,

Greeting for the day. Thank you for reply, but it didn't work.

Kushal_Chawda

@Sagar082  how it did not work? Can you share sample data with expected output?