Load data with Excel

[#1]

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

Name	Data1	Data2
X1	100	45
X2	100	20
X3	102	10

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.

[#2 · Accepted solution]

Hi Javier,

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

Thanks!!

Regards,

Yojas

[salto]

Hi,

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

Regards.

[#4]

Thanks

[salto]

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

[#6]

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