topic Re: include statement in QlikView

include statement

Wed, 25 Mar 2015 12:20:14 GMT

Hi Folks,

I need your extended help.

Unable to include a text file (saved with Encoding Unicode) through include statement , However while including the text file (Encoding ANSI) its reading information successfully.

for your ref.

Script snapshot :

Re: help

Wed, 25 Mar 2015 12:43:05 GMT

Hi @Arn Brien

Check this link

Include File in Qlikview: How to use it to Simplify Your Scripts « Learn Qlikview

check this thread also for example

Writing "Hello World" to a text file from the script

Re: include statement

giakoum — Wed, 25 Mar 2015 13:02:11 GMT

these characters mean nothing for the QV scripting engine.

Re: include statement

Wed, 25 Mar 2015 13:12:54 GMT

Actually that is my concern, This occurs only when I am including a Unicode text file , how ever if I am including a ANSI text file then its running successfully.

How can an Unicoded text file be included ?

Re: include statement

prieper — Wed, 25 Mar 2015 13:24:17 GMT

Can you post an example?

Peter

Re: include statement

Wed, 25 Mar 2015 13:46:01 GMT

Attached two text files with same text (one in UNICODE & another in ANSI encoding) which need to call in include statement in qlikview.

Just create a simple qlikview doc. and try including separately these files.

For ex. $(must_include=path\ANSI.txt);

I am sure you can see the difference.

Re: include statement

prieper — Wed, 25 Mar 2015 14:09:31 GMT

What about a workaround - data can be loaded with "Character Set":

Command:

LOAD

FROM

[.\unicode.txt]

(txt, unicode, no labels, delimiter is ';', msq);

LET sCommand = PEEK('@1', 0, Command);

$(sCommand); // executes the command

DROP TABLE Command; // clean up

Noticed that statements in your files should be ending with a ";"

HTH Peter

Re: include statement

Wed, 25 Mar 2015 14:25:28 GMT

Thanks for the work around Peter .

But I just wonder why Qlikview can't read Unicode text through include statement !!!

Re: include statement

prieper — Wed, 25 Mar 2015 14:29:54 GMT

Suggest to post this as idea

Peter

Re: include statement

Wed, 25 Mar 2015 14:35:10 GMT

Thank you Peter, that I am going to do.....