topic SQL select * FROM sql.db where record EXISTS in QVD in QlikView

SQL select * FROM sql.db where record EXISTS in QVD

SimonDB — Fri, 15 Nov 2024 23:49:36 GMT

Hi, I'm trying to do a load from a SQL database with a where clause that looks at a QVD. Is this possible?

Something like this

LOAD
Record,
Name,
Address;
SQL SELECT *
FROM $(vDB).customer
WHERE Record IN [D:\MyTable.QVD] (QVD);

MayilVahanan — Mon, 12 Oct 2020 10:46:49 GMT

Hi Simon,

Try like this

Temp:

Load Distinct Record from [D:\MyTable.QVD] (QVD);

LOAD
Record,
Name,
Address where exists(Record);
SQL SELECT *
FROM $(vDB).customer;

or you can use inner join also.

Temp:

Load Distinct Record from [D:\MyTable.QVD] (QVD);

Inner Join

LOAD
Record,
Name,
Address;
SQL SELECT *
FROM $(vDB).customer;

sunny_talwar — Mon, 12 Oct 2020 11:49:45 GMT

@SimonDB Or the third option is to construct a variable which can then be passed to your sql

Temp: LOAD Concat(DISTINCT Chr(39) & Record & Chr(39), ',') as ConcatRecord From [D:\MyTable.QVD] (QVD); LET vConcatRecord = Peek('ConcatRecord');

and then you can use this variable in your SQL

LOAD Record, Name, Address; SQL SELECT * FROM $(vDB).customer WHERE Record IN ($(vConcatRecord));

SimonDB — Tue, 13 Oct 2020 21:44:10 GMT

Thank you both for your replies