I am trying to convert 32 character hex string generated using md5 to an integer to get mod 10000. Can someone help me with this? The steps I followed are as below: Using derived column in Azure data factory Dataflow and inside expression builder, I am adding the below text: md5(id) where id can be any constant for example.
The above command provides 32 character Hex string. Now I would like to convert it to an integer and then take mod(%) of 100000.