Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mgolinvaux
New Contributor II

Re: Problem with numbers with SQL select script

Hello,

Unfortunately, the WORK_ID is not always a 4 digit number, sometimes it's more.

Regards.

mgolinvaux
New Contributor II

Re: Problem with numbers with SQL select script

Hello,

That's exactly the problem!

Some data in my source table contains "62".

I will solve this in the source table and the script should be working fine.

I just need to wait tomorrow because the source table is reloaded one time a day.

Regards.

mgolinvaux
New Contributor II

Re: Problem with numbers with SQL select script

Hello,

I can tell now that was exactly the problem. After suppressing the values with "62", my script works fine and load the lines with "0062" without problem.

Thanks!

stabben23
Honored Contributor

Re: Problem with numbers with SQL select script

Great, QlikView is sometimes to smart for it self