Hi, I have been moving my work from excel to alteryx and now I have got a challenge I can not overcome. I want to replace count-if and rank from excel in alteryx. I used transpose with group by with nil luck.
Here is my data file:
| System | Sub-System | Count | Rank |
| A | AA | 3 | 1 |
| A | BB | 2 | 1 |
| A | AA | 3 | 2 |
| B | BB | 2 | 1 |
| B | AA | 3 | 3 |
| B | CC | 1 | 2 |
I have tried to get Count column that is Count-in on Sub-system and Rank column that shows the items rank when they appear in the the file. I need Rank to filter out further down the line.
