Skip to main content
Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
cyrilleleja
Contributor
Contributor

Issue in data after transform

Hello,

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

Issue1.jpg

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

Issue2.jpg

could you please help ?

regards,

Cyrille

4 Replies
larouge69
Contributor III
Contributor III

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
Contributor
Contributor
Author

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
Contributor
Contributor
Author

I have tried this :

APPLYMAP( 'bank_numberMapping', text()) AS

,

but still doesn't work

larouge69
Contributor III
Contributor III

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