Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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,
...
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,
...