Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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
Yes, they have the same structure, so I need to add the rows from data5 to data1.
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);
I think I've solved the question, try the ayttachment
Thanks for your help guys!
Ivelin