topic Re: How to Concatenate and Join Result to SQL/ODBC Connection? in QlikView

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

Fri, 02 Oct 2015 20:28:41 GMT

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 — Fri, 02 Oct 2015 22:10:19 GMT

TableFromSql:

sql select * from ....:

Tempexceltable:

Load * from excelfile1:

Concatenate(Tempexceltable)

Load * from excelfile2;

Left join(TableFromSql)

Load * Resident Tempexceltable;

Drop table Tempexceltable;

Fri, 02 Oct 2015 22:21:11 GMT

Thank you very much, ‌Simen!

qlikviewwizard — Sat, 03 Oct 2015 05:17:46 GMT

Hi,

Check this.

Anonymous — Sat, 03 Oct 2015 09:06:31 GMT

please provide table structures,so can help

jagan — Sat, 03 Oct 2015 09:09:51 GMT

Hi,

Try like this

Connect ODBC;

TableName:

SELECT * FROM TableName;

Concatenate(TableName)

LOAD

FROM ExcelFileName;

HOpe this helps you.

Regards,

Jagan.