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
2 Likes
Dear johannes
It is not working and return missing values. 
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.