Convert ASCII text type to integer in qliksense

[Aspiring_Developer]

Hello All ,

I have below fields:-

I am trying to convert Build_UPRN into integer but it not populating . I tried below :- Floor(num(Build_UPRN)) as Num_Build_UPRN , 

It didn't worked . I am trying to convert this field into num as i need to join these two tables on this field and since the data type of both the field in different, it is creating error . Can anyone please help me with this ?

Thanks in advance

[Aspiring_Developer]

Hello All,

I also tried  Floor(num#(Build_UPRN)) as Num_Build_UPRN  but still it does not work

[TauseefKhan]

Hi @Aspiring_Developer,
The below code helps in replacing characters with ASCII codes in a string in Load scrip

MapTable:
Mapping LOAD
Chr(RecNo() - 1) AS Char,
RecNo() - 1 AS Asciicode
AutoGenerate 256;

Data:
LOAD
Num,
MapSubString('MapTable', Num) as IntegerField
FROM DataSource;

** When applicable please mark the correct/appropriate replies as "solution".Please LIKE threads if the provided solution is helpful to. **

[SunilChauhan · Accepted solution]

Try
1.Floor(num#(Trim(Build_UPRN)))

or 
2.Floor(num#(Trim(Replace(Build_UPRN,' ',''))))