Hi all,
I I would like to replace some of ID in the "ID code" column. Please advise how I could do it in Alteryx? I list below examples of what I want.
Before:
| Company Name | ID code | Total |
| Company A | 1 | 100 |
Company B | 2 | 200 |
Company B | 3 | 300 |
| Company D | 4 | 400 |
| Company E | 5 | 500 |
| Company F | 6 | 600 |
| Company G | 7 | 700 |
| Company H | 8 | 800 |
| Company I | 9 | 900 |
After:
| Company Name | ID | Total |
| Company A | 1 | 100 |
Company B | BB | 200 |
Company B | BB | 300 |
| Company D | DE | 400 |
| Company E | DE | 500 |
| Company F | 6 | 600 |
| Company G | OTH | 700 |
| Company H | OTH | 800 |
| Company I | OTH | 900 |
Cheers,
J
