How to where clause in Load script

[wallerjc]

hi i'm trying to do the below, but coming up short, i know it's simple just hoping for a second pair of eyes:

Customers:

LOAD CustomerID,

     ThesaurusID as theID,

     PostCode,

     CountryCode,

     GenderName,

     DateOfBirth,

     MailPreference,

     EmailPreference,

     RentPreference,

     TelephonePreference

FROM

(txt, unicode, embedded labels, delimiter is ',', msq)

where count(PostCode) <15;

I know my aggregation is wrong, but I'm not sure how to go about this in either a qlikview expression nor in the load script.

Thanks,

[its_anandrjs · Accepted solution]

Do not use the Count in the where expression write like

Customers:

LOAD CustomerID,

     ThesaurusID as theID,

     PostCode,

     CountryCode,

     GenderName,

     DateOfBirth,

     MailPreference,

     EmailPreference,

     RentPreference,

     TelephonePreference

FROM

(txt, unicode, embedded labels, delimiter is ',', msq)

where  PostCode < 15;

You can use variables for this also

Regards,

Anand

[wallerjc]

just realised this is a stupid question not sure how to delete.

sorry

[JonnyPoole]

i think you can only mark as correct in order to close the thread.

So mark yourself or ashfaq as correct.

(There are no st*pid questions)

[its_anandrjs]

Sorry jonathan its Anand

@James mark any Question Correct or Help Full to close the thread its a very simple question some time mistake dones.

Regards,

Anand

[JonnyPoole]

Oops my bad !.  I saw the big 'A' icon and my brain made a wrong turn.

[#7]

James mark any Question Correct or Help Full to close the thread