Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm a new user to QlikView and have been reviewing the Community for answers to my current issue:
I'm have a data set that has a "*" as a prefix to the data (IE: *79-XXXXX). In order for me to correctly join this with our other item fields it needs to be stripped of the "*".
My questions:
1) How do I accomplish this?
2) Where do I put this conversion in? Load script or after the data is the QVW?
Thank you-
AJ
To allow QV to join or link the tables, you need to do this in the load script.
Maybe you could use purgechar() to get rid of the '*' (if you don't have multiple occurences of '*' later on in your field value, like *79-XXXX*Y )
LOAD
purgechar(FIELD,'*') as FIELD,
...
FROM ...
or use mid() function
LOAD
mid(FIELD,2) as FIELD,
...
FROM ...
To allow QV to join or link the tables, you need to do this in the load script.
Maybe you could use purgechar() to get rid of the '*' (if you don't have multiple occurences of '*' later on in your field value, like *79-XXXX*Y )
LOAD
purgechar(FIELD,'*') as FIELD,
...
FROM ...
or use mid() function
LOAD
mid(FIELD,2) as FIELD,
...
FROM ...
Swuehl,
The string purgechar worked. Thank you!