Quick question on Join and Concatenate

[#1]

Hi,

thanks to our community I managed to solve a problem with combining data from different sources (http://community.qlik.com/message/306593#306593).

However, there is still a bit of data left that has to be merged with the rest - sheets 'data1' and 'data5'. I tried Concatenate (data5) which I believe should be the way but I'm doing something wrong.

Regards,

Ivelin

[alexandros17]

I have not understood if Data 5 has to be linked only to ID1 or even to the field "date" loaded from sheet1

I noticed that sheet 1 and sheet5 have the ame structure so if you need to link data only to ID1 then load sheet1 and sheet5 and concatenate data then left join the main table to the set obtained from  Sheet1 and 5

Hope it helps

[#3]

Yes, they have the same structure, so I need to add the rows from data5 to data1.

[Gysbert_Wassenaar · Accepted solution]

Try concatenating data1 and data5 first before joining them to map1:

Map1:

LOAD ID1,

     date,

     visitors

FROM

local.xlsx

(ooxml, embedded labels, table is data1);

LOAD ID1,

     date,

     visitors

FROM

local.xlsx

(ooxml, embedded labels, table is data5);

Join (Map1)

LOAD

    ID1, ID3

FROM

local.xlsx

(ooxml, embedded labels, table is local);

[alexandros17]

I think I've solved the question, try the ayttachment

[#6]

Thanks for your help guys!

Ivelin