topic Re: Load Script with where condition -> No record loaded in QlikView

Load Script with where condition -> No record loaded

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Load Script with where condition -> No record loaded

swuehl — Mon, 12 Jun 2017 09:30:42 GMT

Both LOADs should be un-optimized QVD LOADs, so not differ too much in terms of duration.

Are you more concerned about the duration or about the zero records returned?

If latter, you need to investigate how the field values of field SDDRQJ look like.

Re: Load Script with where condition -> No record loaded

qlikviewaf — Mon, 12 Jun 2017 09:32:09 GMT

My issue is that after 6 mins i still have 0 record loaded - so seems that something is not working.

DRQJ is a julian date.

What can i do?

Re: Load Script with where condition -> No record loaded

Anonymous — Mon, 12 Jun 2017 09:36:02 GMT

try using request_date ...

Re: Load Script with where condition -> No record loaded

lalitkgehlot89 — Mon, 12 Jun 2017 09:37:38 GMT

Hi Antonio,

check field values format of field SDDRQJ.

Where condition field format should be simile.

Re: Load Script with where condition -> No record loaded

qlikviewaf — Mon, 12 Jun 2017 09:41:06 GMT

Data Type is Number.

I GOT AN ERROR

Re: Load Script with where condition -> No record loaded

qlikviewaf — Mon, 12 Jun 2017 10:15:51 GMT

Any Idea? Suggestion?

Re: Load Script with where condition -> No record loaded

Anil_Babu_Samineni — Mon, 12 Jun 2017 10:23:13 GMT

You can use Where SDDRQJ >= 117000;

Make sure, Your date format

Re: Load Script with where condition -> No record loaded

qlikviewaf — Mon, 12 Jun 2017 10:30:25 GMT

is what i have done at the beginning.

i checked on the DB and the SDDRQJ is Numeric.

So there's no why to load using SDDRQJ greater than 117000 ?

Re: Load Script with where condition -> No record loaded

Anil_Babu_Samineni — Mon, 12 Jun 2017 10:33:46 GMT

Would you provide screenshot for SDDRQJ, How data looks like? Could be the reason of 117000. May be use single quote for that

Re: Load Script with where condition -> No record loaded

qlikviewaf — Mon, 12 Jun 2017 10:40:23 GMT

Here we are

Re: Load Script with where condition -> No record loaded

Anil_Babu_Samineni — Mon, 12 Jun 2017 10:46:02 GMT

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

Re: Load Script with where condition -> No record loaded

Anonymous — Mon, 12 Jun 2017 10:46:34 GMT

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

Re: Load Script with where condition -> No record loaded

qlikviewaf — Mon, 12 Jun 2017 10:49:12 GMT

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)

Re: Load Script with where condition -> No record loaded

stabben23 — Mon, 12 Jun 2017 11:00:43 GMT

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

Re: Load Script with where condition -> No record loaded

swuehl — Mon, 12 Jun 2017 11:06:56 GMT

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?

Re: Load Script with where condition -> No record loaded

stabben23 — Mon, 12 Jun 2017 11:29:58 GMT

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

Re: Load Script with where condition -> No record loaded

swuehl — Mon, 12 Jun 2017 11:40:01 GMT

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.

Re: Load Script with where condition -> No record loaded

stabben23 — Mon, 12 Jun 2017 12:01:43 GMT

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

Re: Load Script with where condition -> No record loaded

qlikviewaf — Mon, 12 Jun 2017 13:01:12 GMT

Hi Stefan,

i confirm both.

The screenshot is based on different script.

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