Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
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
these characters mean nothing for the QV scripting engine.
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 ?
Can you post an example?
Peter
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.
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
Thanks for the work around Peter .
But I just wonder why Qlikview can't read Unicode text through include statement !!!
Suggest to post this as idea
Peter
Thank you Peter, that I am going to do.....