Unique Column Headers

[skotian1289]

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

[atcodedog05]

Renaming is solved.

[vizAlter · Accepted solution]

@skotian1289 — Now, try this one based on your sample file:

[vizAlter]

@skotian1289 — (FYI) Alteryx has very good interactive sessions about RegEx Learning too.

[atcodedog05]

_

[atcodedog05]

Happy to help : ) @skotian1289