This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi! I have the following problem:
I need to create ID for positions like in the following example:
Position | ID |
A | 1 |
A | 1 |
A | 1 |
B | 2 |
B | 2 |
C | 3 |
I tried to use multirow formula
IF [Row-1:Position]=[Position] THEN [Counter_id] = [Row-1:Counter_id] ELSE [Counter_id] = [Row-1:Counter_id] + 1 ENDIF
Where column [Counter_id] is initially a column with 1 in every row. But result column shows wrong answer - there are only 0 and -1 values
Thanks for any help
Hi @Nastya
Use Tile Tool with Unique Value method:
Unique Value being your Position field.
The Tile_Num field would be your ID now.
Cheers,
@Nastya Very close! I would try something like this:
IF [Row-1:Position]=[Position] THEN [Row-1:Counter_id] ELSE [Row-1:Counter_id] + 1 ENDIF
Hi Nastya,
You can create a column whose value is 1 and then create the ID column by creating a running total of the same column and grouping by the "Position" column .
Thanks,
Ankit.