%(fieldname) in load script

[gino2780]

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!

[sunny_talwar]

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]

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