topic Re: Import sql file into qlikview in QlikView

Import sql file into qlikview

Anonymous — Wed, 22 Aug 2018 15:43:47 GMT

Hi,

I know that I can do SQL queries inside the script using the

SQL SELECT * FROM table1;

syntax. However, I have a file called queryTable1.sql which contains the same line above and would like to know if I can import this file into the script and run the query without copy pasting the content.

Thanks in advance!

Re: Import sql file into qlikview

ogautier62 — Fri, 24 Aug 2018 06:40:31 GMT

Hi,

I think it should work with :

$(include = "your query file.sql")

regards

Re: Import sql file into qlikview

Peter_Cammaert — Fri, 24 Aug 2018 08:50:55 GMT

Your query file looks like an export from some RDBMS. If that's the case, remember to put a SQL keyword in front of Olivier's $Include construct, as it doesn't usually come with regular SQL statements and is a QlikView Script requirement.

Re: Import sql file into qlikview

BalaBhaskar_Qlik — Fri, 24 Aug 2018 13:29:32 GMT

Insert - Include Statement - select the required file.

$(Include=D:\..\..\desktop\sales dashboard\module.txt);

$(Include=sales_orders.qvs);

$(Include=queryTable1.sql);

Re: Import sql file into qlikview

adambrian — Thu, 20 Feb 2020 02:22:45 GMT

Hi,

i am new in qlikview.. can you show full script when export local sql file into qlikview?

@ogautier62 @Anonymous

Thanks,