Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following load script?
Table1:
Load
`Atribute1`,
`Atribute2`
from
../QVD/DATA/Table1.csv
(txt, utf8, embedded labels, delimiter is '\t', msq);
it works without `. So what effect has ` ?
Hi Markus,
It will be used for the field names with space in it Eg: `Attribute 1`.
If there is no space in between, no need for that. But QlikView has some less intelligence, so it would have used grave ascent for all the field names.
your script with apex will load all equal rows, each one with values
'Atribute1`, `Atribute2`
if you remove apex you will load fields values (the real one contained in table)
Let me know
I both cases the data is loaded correctly. It seems to have no effect.
See: QlikView Quoteology
Thanks for the link it's really helpful.
Double quotes can always be substituted by square brackets or by grave accents.
So it between douple quotes, square brackets or grave accent is no technical difference?
I ask because, if you use the Create Select Statement Wizard, QlikView automatically set the attribute names in grave accent. From my experience there is no benefit in it and i would like to know if I'm correct.
Hi Markus,
It will be used for the field names with space in it Eg: `Attribute 1`.
If there is no space in between, no need for that. But QlikView has some less intelligence, so it would have used grave ascent for all the field names.
Quotes with Select statement depends on DB, however, with different quotes around field names would not make any difference to qv.
Ok but I could use also double quotes, square brackets or grave accent. It is a design choice?