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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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,

...