Hi All,
I know this could be a simple solution but I need help as I am quite new to Alteryx.
My input file has 100s of column headers and some column headers are repeated multiple times. I want to give a unique numbers to each column headers because I want to reconcile them. In excel I am able to perform that step by using the below formula.
A2&"/"&COUNTIF(A$2:A2,A2) (A2 value being 1)
See sample of what I am trying to achieve in alteryx, let me know if anyone can help me
Input File Column headers:
Blue Green Red Blue Red Blue Yellow Green
Expected Resuts:
Blue/1 Green/1 Red/1 Blue/2 Red/2 Blue/3 Yellow/1 Green/2
Thanks
Solved! Go to Solution.
Renaming is solved.
@skotian1289 — (FYI) Alteryx has very good interactive sessions about RegEx Learning too.
_
Happy to help : ) @skotian1289