topic Quick question on Join and Concatenate in QlikView

Quick question on Join and Concatenate

Fri, 01 Feb 2013 12:48:37 GMT

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

Re: Quick question on Join and Concatenate

alexandros17 — Fri, 01 Feb 2013 13:03:26 GMT

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

Re: Quick question on Join and Concatenate

Fri, 01 Feb 2013 13:11:47 GMT

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

Re: Quick question on Join and Concatenate

Gysbert_Wassenaar — Fri, 01 Feb 2013 13:29:39 GMT

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);

Re: Quick question on Join and Concatenate

alexandros17 — Fri, 01 Feb 2013 13:50:54 GMT

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

Re: Quick question on Join and Concatenate

Mon, 04 Feb 2013 14:12:30 GMT

Thanks for your help guys!

Ivelin