Dear All
I am trying to working on some data preparation as below, so that I could work on a countif function to identify any duplicate, however the original 2 sets of data had different format of the ID number, wondering is there anyway to solve this issue.
As below the ID contains "000", "00", "0" in some ID, but in excel logic it still able to perform the countif regardless there are extra digit at the beginning, in Alteryx I believe I have to clear those"000", appreciate your help. thank you
Company A | 8170353 |
Company A | 0008170353 |
Company B | 99322370 |
Company B | 009322370 |
Company C | 109503349 |
Company C | 0109503349 |
Company D | 8171160 |
Company D | 0008171160 |
Company E | 4838410 |
Company E | 0004838410 |
Solved! Go to Solution.
@jeffwongarrow
Hope this is what you need.
Appreciate you would mark it as accept if you find it useful.
this is working perfectly, thanks a lot.
@jeffwongarrow
Thank you for the mark also.