Discussion Board for collaboration related to QlikView App Development.
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.tablesWHERE table_schema=$(vTableSchema) AND TABLE_NAME IN ('countries', 'adventures_professionnal');
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.
View solution in original post
My best guess is that you need quotes around your variable expansion. Like this: