Forum Discussion
Solved
Count the Variable when it appear the first time
Hi, i have a table with many variables and it have duplicates, what i want to do is to have count for the variable when it appear the first time and does not count the variable when is appear the sec...
Hi again,
Yes, it is possible please follow these few steps (after adding index column):
1. Group by with counting all rows:2. Expand only index
3. Add a conditional column
4. remove unnecessary columns
RESULT :If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi again,
Yes, it is possible please follow these few steps (after adding index column):
1. Group by with counting all rows:
2. Expand only index
3. Add a conditional column
4. remove unnecessary columns
RESULT :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
