Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

New to QlikCommunity - Need some help

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

1 Solution

Accepted Solutions
MVP
MVP

Re: New to QlikCommunity - Need some help

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 ...

2 Replies
MVP
MVP

Re: New to QlikCommunity - Need some help

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 ...

Not applicable

New to QlikCommunity - Need some help

Swuehl,

The string purgechar worked. Thank you!