topic Re: Loading values beginning with particular criteria in QlikView

Loading values beginning with particular criteria

Thu, 17 Mar 2016 23:08:21 GMT

I have a field 'account_no' which consists of the following :

1213980

1213950

AA12/400

AA13/500

Id like to know how to load only those values beginning with 'AA'

Re: Loading values beginning with particular criteria

swuehl — Thu, 17 Mar 2016 23:17:10 GMT

Maybe like

LOAD

[account_no]

FROM Source

WHERE [account_no] LIKE 'AA*';

Instead of LIKE, you can also use

WHERE Left([account_no],2) = 'AA';

WHERE WildMatch([account_no], 'AA*');

Re: Loading values beginning with particular criteria

MarcoWedel — Thu, 17 Mar 2016 23:33:55 GMT

If you don't want to exclude records having account_nos starting with something else than 'AA' from being loaded and just want to suppress the faulty account_nos instead, then one solution could be:

LOAD If(account_no like 'AA*', account_no) as account_no
From YourSource;

still loading all records but replacing other account_nos than 'AA*' with null.

hope this helps

regards

Marco

Re: Loading values beginning with particular criteria

sunny_talwar — Fri, 18 Mar 2016 01:03:01 GMT

This should also work if you want to pull everything text and exclude everything number:

Table:

LOAD Field

Where IsText(Field);

LOAD * Inline [

Field

1213980

1213950

AA12/400

AA13/500

];

Re: Loading values beginning with particular criteria

jagan — Fri, 18 Mar 2016 02:00:32 GMT

Hi,

Try like this using LIKE

Data:

LOAD

[account_no],

FROM DataSource

WHERE [account_no] LIKE 'AA*';

Data:

LOAD

[account_no],

FROM DataSource

WHERE WildMatch([account_no], 'AA*');

Hope this helps you.