ALTERYX ADD NEW COUNTER COLUMN

[sanjit11]

PFA the attached data.

I want to generate the counter column marked in red.

if someone could assist that would be great!!

thanks

[atcodedog05]

Hi @sanjit11 

If you can explain the logic behind the counter column we will be happy to help you out 🙂

[sanjit11]

So Basically ,

Each component name has a fixed set of criterias.

For each function name a component with its set of criterias can occur only once.

But as you can see in rows 14 to 19,

For "XYZ" , "Checks" with its criterias "G H and I" has occurred twice

so the counter there is 2

I hope this makes sense 🙂

[sanjit11]

@atcodedog05 

[atcodedog05 · Accepted solution]

Hi @sanjit11 

Here is how you can do it.

Workflow:

1. Using summarize groupby on Functional Team, Component/Survey Name and Criteria. And get count of avg score (can be any column).

2. Using join tool with key Functional Team, Component/Survey Name, and Criteria to join it back to the data.

Hope this helps : )

[sanjit11]

@atcodedog05 thts great, thanks a TON!!

[atcodedog05]

Happy to help : ) @sanjit11 

Cheers and have a nice day!