Converting Hexadecimal to number

Hi all
I urgently need to convert a column with hex format to number, unfortunately i have no clue. I need the column to join table with another one in which same column has number data type! Would you please assist?

Hi @sepideh,

you could use a Java Snippet (simple) node to do that.

return Integer.parseInt($column1$, 16); in the method body worked for me.
Cheers,
Johannes

1 Like

Dear johannes
It is not working and return missing values. :frowning:

I don’t know what your data looks like. In my sample workflow it works.

hex.knwf (7.0 KB)

3 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.