Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Converting Long string (15 Chars) to numeric

I need to convert it from text to numeric. I tried everything  with no success. This issue is linking this field one is char and the other is numeric.

Data Sample:

200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200807281045571
200812181504752
200812181504752
200812181504752
200812181504752
200812181504752
200812181504752
200812181504752
200812181504752
200812181504752
200812181504752
200812181504752
200812181504752
200812181504752
1 Solution

Accepted Solutions
swuehl
MVP
MVP

Yeah, I remember I ran into the same issue some time ago. Not very intuitive, but I think the solution was to use

LOAD

evaluate(FIELD) as FIELD,

...

View solution in original post

1 Reply
swuehl
MVP
MVP

Yeah, I remember I ran into the same issue some time ago. Not very intuitive, but I think the solution was to use

LOAD

evaluate(FIELD) as FIELD,

...