How to match a different row names into unique names in QlikView

[Anonymous]

Hi Friends any quick help on of the below Problem:

I have a Dimension Quantity which has certain data as A,B,C,D..

A=A-XYZ(Here A & A-XYZ are same need to display as A)

N=NO(Here N &NO are same need to display single row as N)

And Finally need to group values of #N/A,N,None as NO Score?

How we can achieve this in QlikView please do needful?

Quantity

A

A-XYX

B

C

D

N

NO

#N/A

None

[awhitfield]

LOAD
Distinct(Left(Quantity,1)) as Quantity

[stigchel]

Hi,

In the load script you can use a mapping load first which you can then apply to your field quantity e.g.

MyMap:

mapping load * inline [From,To

'#N/A','NO'

'None','NO'

'N','NO'

];

Load.....

...

Applymap('MyMap', Quantity,Quantity) as Quantity,

....

From....

[jyothish8807]

Hi,

Try this:

Tab1:

LOAD * INLINE [

    Quantity

    A

    A-XYX

    B

    C

    D

    N

    NO

    #N/A

    None

];

Tab2:

lOAD *,

replace(replace(Quantity,'A-XYX','A'),'NO','N') as QuantityN

resident Tab1;

drop Table Tab1;

Regards

KC

[maxgro]

load

  Quantity,

  pick(wildmatch(Quantity, '#N/A', 'N', 'None', 'A', '*'),   'NO', 'NO', 'NO', 'A-XYZ', Quantity) as NewQuantity   

inline [

Quantity

A

A-XYX

B

C

D

N

NO

#N/A

None

];

[stigchel]

Has this answered your question? If so, can you please close this thread by marking one of the answers correct? It will help others find a (correct) answer to similar problems and lets other contributing members know that this requires no more attention.