Discussion Board for collaboration on QlikView Scripting.
Mission of this topic to give a brief description of code places, where it can't be an error, but it happens.
Sometimes it can proceed without any warnings...
And you can't understand, why doesn't your application works in proper way.
I assume, it would be most effective for beginners, like I'm.
LOAD * Inline [
load data without spaces in the beginning. I faced with this problem tonight.
xls-source contains spaces as hierarchy markers. And it was imbalanced tree.
I don't know, how to avoid it.
I tried with xls
'A' & F1 as F1
First of all, QV decides to remove spaces and returns smth like that
Please, response here if you know how to solve this problem. And I would be glad if you double your answer to my mail
It is not a bug. This is the way it is designed. Normally you want to strip all leading and trailing blanks.
However, you can turn this off by using
set Verbatim = 1;
before your load statement.
As Henric Cronström said, set Verbatim = 1 is exactly what you need