Issue in data after transform

[cyrilleleja]

Hello,

this is my issue, i make a mapping to transform numeric field in a string :

I save and reload data, but in my dashboard i still have numéric value like below  :

could you please help ?

regards,

Cyrille

[larouge69]

Hi,

To force the format of your data, in the load statement you can make a :

text([your field]) as your_field_name

It should be considered as a text format.

[cyrilleleja]

Hello David,

thanks I have this :

:

MAPPING LOAD * INLINE[environmentMapping-FROM,environmentMapping-TO

bpce,BPACAca,CAPCA];[bank_numberMapping]:MAPPING LOAD * INLINE[

bank_numberMapping-FROM,bank_numberMapping-TO13507,BPN18707,BPVF17515,CEIDF

13825,CERA11315,CEPAC18315,CECAZ12135,CEBFC10207,BPRI14707,BPALC14607,BPMED

];[shop]:

How i can proceed ?

thanks a lot

Cyrille

2018-07-11 0:15 GMT+02:00 David B. <qcwebmaster@qlikview.com>:

[cyrilleleja]

I have tried this :

APPLYMAP( 'bank_numberMapping', text()) AS

,

but still doesn't work

[larouge69]

Hi Cyrille,

I think your mapping table should look like that :

MAPPING

[bank_numberMapping]:

LOAD * INLINE [

bank_numberMapping-FROM, bank_numberMapping-TO

13507,BPN

18707,BPVF

17515,CEIDF

13825,CERA

11315,CEPAC

18315,CECAZ

12135,CEBFC

10207,BPRI

14707,BPALC

14607,BPMED

]

;

Then,

ApplyMap('bank_numberMapping', [field name you want to map with bank_numberMapping-FROM], 'default value whe if needed') as [bank_numberMapping-TO]

Be carefull with '-' sign in your field names. It could considered as an operator. Use brackets [] to avoid it, or dont use them.

Let's try

bye