Discussion Board for collaboration on QlikView Scripting.
I have the following problem:
LOAD * INLINE [
as result I want to have
is there any way to do this. I cannot use IntervalMatch because A,B,C are not numeric.
Hi, just add another table:
left(account,1) as bipo
thanks for the answer
but I had simplified the example
It is not allways the first digit
e.g. EINVER1010, EINVER1020, EINVER1030 have to be associated to EINVER
AUSZ_0510, AUSZ_0530, AUSZ_0540 habe to be associated to AUSZ
I am looking for a solution where I can work with wild cards
pick(wildmatch(account, 'EINVER*', 'AUSZ*'), 'EINVER', 'AUSZ') as bipo
You can easily add another prefixes.
The Qlikview Cookbook http://robwunderlich.com/downloads
has an example named "Mapping with a table using wildcards" that shows how to use a mapping table with wildcards.
Qlikview Components http://qlikviewcomponents.org has an even easier method:
CALL Qvc.CreateWildMapExpression (vMapExpr, WildMapTable);