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 ?
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.
thanks I have this :
MAPPING LOAD * INLINE[environmentMapping-FROM,environmentMapping-TO
bpce,BPACAca,CAPCA];[bank_numberMapping]:MAPPING LOAD * INLINE[
How i can proceed ?
thanks a lot
2018-07-11 0:15 GMT+02:00 David B. <firstname.lastname@example.org>:
I have tried this :
APPLYMAP( 'bank_numberMapping', text()) AS
but still doesn't work
I think your mapping table should look like that :
LOAD * INLINE [
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.