Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Unveils New Agentic Capabilities Across Analytics, Data Engineering, and Trust: 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
Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

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
Champion III
Champion III

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,

...