topic Issue in data after transform in Francophones

Issue in data after transform

cyrilleleja — Wed, 04 Jul 2018 08:13:47 GMT

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

Re: Issue in data after transform

larouge69 — Tue, 10 Jul 2018 22:14:52 GMT

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.

Re: Issue in data after transform

cyrilleleja — Fri, 13 Jul 2018 07:44:14 GMT

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

Re: Issue in data after transform

cyrilleleja — Fri, 13 Jul 2018 12:09:27 GMT

I have tried this :

APPLYMAP( 'bank_numberMapping', text()) AS

but still doesn't work

Re: Issue in data after transform

larouge69 — Tue, 17 Jul 2018 21:42:11 GMT

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