How to Concatenate and Join Result to SQL/ODBC Connection?

[#1]

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.

[simenkg]

TableFromSql:

sql select * from ....:

Tempexceltable:

Load * from excelfile1:

Concatenate(Tempexceltable)

Load * from excelfile2;

Left join(TableFromSql)

Load * Resident Tempexceltable;

Drop table Tempexceltable;

[#3]

Thank you very much, ‌Simen!

[qlikviewwizard]

Hi,

Check this.

concatenate two same tables with different schema

[Anonymous]

please provide table structures,so can help

[jagan]

Hi,

Try like this

Connect ODBC;

TableName:

SELECT * FROM TableName;

Concatenate(TableName)

LOAD

*

FROM ExcelFileName;

HOpe this helps you.

Regards,

Jagan.