topic Re: Load data with Excel in QlikView

Load data with Excel

Tue, 29 Oct 2013 02:10:18 GMT

Hi everybody, I have an Excel 1 file with this structure, the data changes everyday:

And an Excel 2 file with this structure:

Data1	Data2	Value1	Description1
120	15	59	A8B3
100	45	32	LO74
102	10	71	9U4R
90	30	20	K8Y6

When in the morning I load the data from Excel 2, depends what's in the file Excel 1 that day, in this case the result is:

Header 1	Data1	Dat12	Value1	Description1
X1	100	45	32	LO74
X3	102	10	71	9U4R

Then, how I can to combinate the data from Excel 1 and take the values from Data1 and Data2 for only take a few records each day?

Thanks.

Tue, 29 Oct 2013 11:59:40 GMT

Hi Javier,

PFA for your solution. I hope this is what your want.

Thanks!!

Regards,

Yojas

salto — Tue, 29 Oct 2013 12:40:43 GMT

Hi,

seems to be a problem you can fix with a left join from Excel1 on Excel2, on fields Data1 and Data2.

Regards.

Tue, 29 Oct 2013 13:06:57 GMT

Thanks

salto — Tue, 29 Oct 2013 13:07:47 GMT

It is exactly the way that Yojas has solved the problem. His solution is OK.

Tue, 29 Oct 2013 13:08:44 GMT

I had a problem with Chrome and I can't saw the attached file, but after reboot it all ok. Thanks Yojas.