Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, everybody.
I've got an ODBC connection with a SQL Selection containing 2 years worth of data about Orders.
I need to JOIN two Excel tables, each of which contains 1 year of data about Cost.
When I use LEFT JOIN to combine the two Excel tables with the Orders table, only the data from the first Excel table shows up.
I'd like to CONCATENATE the two Excel tables and then JOIN them to the Orders table, but I haven't been able to figure out how to do it.
Your help is appreciated.
TableFromSql:
sql select * from ....:
Tempexceltable:
Load * from excelfile1:
Concatenate(Tempexceltable)
Load * from excelfile2;
Left join(TableFromSql)
Load * Resident Tempexceltable;
Drop table Tempexceltable;
Thank you very much, Simen!
please provide table structures,so can help
Hi,
Try like this
Connect ODBC;
TableName:
SELECT * FROM TableName;
Concatenate(TableName)
LOAD
*
FROM ExcelFileName;
HOpe this helps you.
Regards,
Jagan.