Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem using the where clause in the load script;

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

1 Solution

Accepted Solutions

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]);

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

6 Replies

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]);

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

and , after close_date

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Thank you Max..

Hi,

you Welcome

Your issue is solve or not???

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Hi Max - Yes - resolved - Thanks.

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

Hi,

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

Its good that you got the answer.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.