how to import only sql if load is wriiten?

[#1]

assume i have sql query in a text file. i have to import it in qlikview. the query is just the sql part and the load statement i will write myself. how to do that?

example:

LOAD...

.....

...

.....

SQL

this part will be taken from text file. how to do that?

[sinanozdemir]

Hi,

LOAD

     column1,

     column2,

     columnN;

SQL SELECT *

FROM table;

Hope it helps.

[#3]

thanks for the early reply.

but my doubt is how to import a text file into qlikview that to the file contains only the sql part.

[Anil_Babu_Samineni]

Using include statemenT? Or what are you trying to achieve

[MindaugasBacius]

You might be taking about this:

The sentence would look something like this:

$(Include=c:\users\mindaugasb\desktop\connection.txt);

[#6]

thanks for the reoly.

But I tried it. It is not working. For the include to work your txt file should also contain the LOAD part.

[#7]

thanks for the reply.

But I tried it. It is not working. For the include to work your txt file should also contain the LOAD part.

[sinanozdemir]

Ok.

What you are looking for is a qvs file. So save the txt file as qvs file and use it like the below:

[Anil_Babu_Samineni]

Okay, then you need to split into two text files. One is load and one more is which related to sql. Then use include to get the second text file like sql.

Might be helpful

[#10]

okay thanks. I will try this once.