New to QlikCommunity - Need some help

[#1]

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

[swuehl · Accepted 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 )

LOAD

purgechar(FIELD,'*') as FIELD,

...

FROM ...

or use mid() function

LOAD

mid(FIELD,2) as FIELD,

...

FROM ...

[#3]

Swuehl,

The string purgechar worked. Thank you!