Load Script with where condition -> No record loaded

[qlikviewaf]

Hi,

i created a QVD file (2 GB size) and i created the load script as follow; when i add at the end the "Where (SDDRQJ>=117000)" the script doesn't load the data.

After several mins on F42119 i got still 0 record. Seems like a performance issue. If i leave the where condition, then in few mins i got several millions of rows loaded.

I'm doing something wrong?

Thank you

[qlikviewaf]

Here we are

[Anil_Babu_Samineni]

But, In you where condition it showing as Request_Date. But, In initial seems you used as SDDRQJ. Which one we are talking about?

[Anonymous]

Aren't you loading SDDRQJ as Request_Date?? where have you converted it into Date Format??

[qlikviewaf]

i'm using SDDRQJ now renamed as Request_Date

i did not converted into a date format, i'm filtering direclty using the julian format (SDDRQJ>117000)

[stabben23]

Hi,

Request_Date can not be used in the where condition!

I can see that you are using first 10000 in script, dont!

You also show a dialog that inclunde OrderDate and SDDRQJ as Fields, these Field are not in Your script?

Try Where SDDRQJ >= '117000' ; if that works

[swuehl]

According your sample records, a SDDRQJ value of 117000  would be some years in the future (around 2035).

Are you sure that your data source shows dates in that range?

[stabben23]

But Still Stefan, should´t the where statment Works anyway?

Something is strange in the script, look here:

No date format on SDDRQJ

But In dialog

And Field SDDRQJ shows numeric in dialog if that is correct Field

[swuehl]

I believe the screenshot is based on a table load using a different script than posted above, so no comment on your observation.

My point is different: Are there any values >= 117000 in field SDDRQ at all? Still waiting for a confirmation.

[stabben23]

I'll think, if this is M3 data you work With, that SDDRQJ is Requested quantity or something simular.

[qlikviewaf]

Hi Stefan,

i confirm both.

The screenshot is based on different script.

Now i'm just loading SDDRQJ and filtering using >= SDDRQJ.