topic Re: Variable in schema SQL Statement in QlikView

Variable in schema SQL Statement

Judicael — Sat, 16 Nov 2024 18:24:05 GMT

Hi,

What is the correct statement, i see an error message...

LET vTableSchema ='Appollon';

LOAD TABLE_NAME AS TableNames;
SELECT DISTINCT TABLE_NAME FROM information_schema.tables
WHERE table_schema=$(vTableSchema) AND TABLE_NAME IN (
'countries', 'adventures_professionnal');

Regards,

Re: Variable in schema SQL Statement

Vegar — Tue, 07 Jul 2020 21:38:53 GMT

My best guess is that you need quotes around your variable expansion. Like this:

...

WHERE table_schema='$(vTableSchema)'

Re: Variable in schema SQL Statement

Nicole-Smith — Tue, 07 Jul 2020 21:54:10 GMT

Another alternative to Vegar's response is changing your LET to SET--then the single quotes will stay within the variable and you don't need to add them in the SQL.