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.

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)


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