topic Re: Problem using the where clause in the load script; in QlikView

Problem using the where clause in the load script;

Thu, 09 Apr 2015 08:23:45 GMT

Hi,

Please could someone point me in the right diretion on this.

I'm trying to load this table but only where the Security_Ac field is not blank..... but its erroring and I've tried every Null permiatation I can think of.

Please help! Thank you.

Example of the load script:

SECURITIES_ACCT:

LOAD @1:5 as [Security_Ac],

@6:21 as [Customer_No],

@22:27 as [Close_Date],

FROM

COSMIC_SECURITIES_ACCT.txt

(fix, codepage is 1252, no eof);

Where not IsNull ([Security_Ac]);

Many thanks, Matt

Re: Problem using the where clause in the load script;

PrashantSangle — Thu, 09 Apr 2015 08:45:43 GMT

Hi,

Remove ; before Where clause

SECURITIES_ACCT:

LOAD @1:5 as [Security_Ac],

@6:21 as [Customer_No],

@22:27 as [Close_Date],

FROM

COSMIC_SECURITIES_ACCT.txt

(fix, codepage is 1252, no eof)

Where not IsNull ([Security_Ac]);

Re: Problem using the where clause in the load script;

PrashantSangle — Thu, 09 Apr 2015 08:46:20 GMT

and , after close_date

Regards

Re: Problem using the where clause in the load script;

Thu, 09 Apr 2015 08:50:06 GMT

Thank you Max..

Re: Problem using the where clause in the load script;

PrashantSangle — Thu, 09 Apr 2015 08:54:46 GMT

Hi,

you Welcome

Your issue is solve or not???

Regards

Re: Problem using the where clause in the load script;

Thu, 09 Apr 2015 08:58:53 GMT

Hi Max - Yes - resolved - Thanks.

Not sure how to mark it as resolved.. can only see mark as Helpful.

Re: Problem using the where clause in the load script;

PrashantSangle — Thu, 09 Apr 2015 09:05:11 GMT

Hi,

Good, I just want to confirm that it worked or not??

Its good that you got the answer.

Regards