Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
gino2780
Not applicable

%(fieldname) in load script

Dear community,

i have a real quick question:

1. What does the % symbol do if you place it in front of a generated variable?

E.g.:

LOAD

PLZ,

PLZ as %PLZ

From...

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!

Tags (3)
2 Replies
sunny_talwar
Not applicable

Re: %(fieldname) in load script

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

LOAD PLZ,

           PLZ as %PLZ;

SQL SELECT

     PLZ

FROM .....

gino2780
Not applicable

Re: %(fieldname) in load script

Hi Sunny,

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.

Greets,

gino2780