topic Re: Convert ASCII text type to integer in qliksense in App Development

Convert ASCII text type to integer in qliksense

Aspiring_Developer — Fri, 15 Nov 2024 20:58:02 GMT

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

Re: Convert ASCII text type to integer in qliksense

Aspiring_Developer — Mon, 20 May 2024 12:41:11 GMT

Hello All,

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

Re: Convert ASCII text type to integer in qliksense

TauseefKhan — Mon, 20 May 2024 12:55:17 GMT

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. **

Re: Convert ASCII text type to integer in qliksense

SunilChauhan — Mon, 20 May 2024 13:32:57 GMT

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

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