Help with mapping data

[#1]

Hey guys

I have two fields in a table that i would like to map but dont have a clue how.

There is numbers like this FPWO0006-15+0001 which i would like to map to FPWO so that when i select FPWO then all of them will show and also in the same table numbers like this PCWO0006-15+0001 which i would like to map aswell to PCWO.

Is there a way i can do this in the load script ?

Your help will be greatly appreciated.

[maxgro · Accepted solution]

if your map is always the first 4 chars

you can add a field in the script

left(yourfield, 4) as newfield

and then add a listbox for newfield

[malini_qlikview]

Hi,

if you are looking to remove the numbers and operators in the field and retain only text then you can try the below

Purgechar('Fieldname','0123456789+-*/')

[avinashelite]

please share the sample set of data

[#5]

you can use Purgechar or Left funtions to extract the piece from field value & then use ApplyMap like below:

ApplyMap('Map_table', Left(FieldName,4) , Null() ) AS NewField

              or

ApplyMap('Map_table', Purgechar(FieldName,'0123456789+-/') , Null() ) AS NewField

If you always have first 4 char is your required value then go with Left function.