Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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';
or
WHERE WildMatch([account_no], 'AA*');
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
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
];
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.