Discussion Board for collaboration related to Creating Analytics for QlikView.
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 "*".
1) How do I accomplish this?
2) Where do I put this conversion in? Load script or after the data is the QVW?
Go to Solution.
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 )
purgechar(FIELD,'*') as FIELD,
or use mid() function
mid(FIELD,2) as FIELD,
The string purgechar worked. Thank you!