topic Query in Water Cooler

Query

Thu, 17 May 2012 09:52:23 GMT

I would like to know how can I achieve this SQL query in Qlikview?

SELECT *
FROM tab1 a, tab2 b
where a.AY=b.A_Y
and a.Sem=b.SEM
and a.CC=b.C_CDE& "-" &U_C
and b.ROLE='XXX'
and a.FID <> b.O_PNO;

Query

Jason_Michaelides — Thu, 17 May 2012 09:58:46 GMT

Data:

LOAD * ;

SQL

SELECT *

FROM tab1 a, tab2 b

where a.AY=b.A_Y

and a.Sem=b.SEM

and a.CC=b.C_CDE& "-" &U_C

and b.ROLE='XXX'

and a.FID <> b.O_PNO;

Simples!

Query

Thu, 17 May 2012 10:01:55 GMT

My source tab1 and tab2 are actually exported into excel spreadsheet. Can the above still achieve the same result?

Query

Jason_Michaelides — Thu, 17 May 2012 10:42:03 GMT

Yes of course. Use the wizard to get something like the below, then add the WHERE clause before the last ;

Data:

LOAD *

FROM (Data.xls blah blah blah)

where a.AY=b.A_Y

and a.Sem=b.SEM

and a.CC=b.C_CDE& "-" &U_C

and b.ROLE='XXX'

and a.FID <> b.O_PNO;

Query

Fri, 18 May 2012 03:43:43 GMT

I put my data into access database. When I tried the recommended solution 1, it gave me an error:SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Any advise?

Query

Jason_Michaelides — Fri, 18 May 2012 07:14:15 GMT

Can you post your qvw and access DB?

Are you sure you have the ODBC connection set up correctly?