include statement

[#1]

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 :

[#2]

Hi @Arn Brien

Check this link

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

or

check this thread also for example

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

[giakoum]

these characters mean nothing for the QV scripting engine.

[#4]

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 ?

[prieper]

Can you post an example?

Peter

[#6]

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.

[prieper]

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

Command:

LOAD

  @1

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

[#8]

Thanks for the work around Peter .

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

[prieper]

Suggest to post this as idea

Peter

[#10]

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