Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I download multiple Excel Access files.
There's some errouneous codes and descriptions in some columns.
For example 'not consistent', 'Not Consistent', 'Not consistant', etc...
I actually use multiple if, but I don't like it.
What's your best way to manage that ?
Is applymap adapted for that ?
Hi,
You can use upper(Field) as Field or lower(Field) as Field.
This will do all text same
No there's different kind of errors like 'Not Consistent', 'Not consistant'.
Hi,
You can use WildMatch() function :
if(wildmatch(Field,'*consi*')>0,'Value_you_want', Field)
oh, did not notice that
If you are going to use QlikView Desktop to reload, you can use barryharmsen's code at http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/
ApplyMap() does not handle regular expressions and is case sensitive, as most of QlikView functions for fields.