Discussion board where members can get started with Qlik Sense.
i have a real quick question:
1. What does the % symbol do if you place it in front of a generated variable?
PLZ as %PLZ
And why does a SQL Load seems to have trouble with using this sort of variable generation?
When i load PLZ as %PLZ in a excel file i'm getting no errors after data load, but when i implement PLZ as %PLZ in a SQL Load Script, i get an Error for this specific row in the script.
Any suggestions, or do you need any further information?
Thanks in advance and happy qliking!
1) % sign is sometime used to hide fields. Check here to see more details about that here:
HidePrefix – hiding fields
2) SQL may not have difficulty interpreting your %. May be you can use a Preceding Load to create %PLZ
PLZ as %PLZ;
thanks for your answer. I haven't been able to try this out, because the task has been delayed. But i will try it as soon as possible and reply to this thread.