Hi guys,
I have a table that is filtered duplicated users like below.
I want to create a new column that is flagged as "Revoke" based on each duplicated User according to its "Last Login" column which is oldest one.
That means flag the each duplicated user's row which is older "Last Login" date than the other in the same user as "Revoke" who has more than one "Last Login" entry.
Any ideas !
My Dataset
User | Version | Device ID | Last Login |
A | 2020.4 | 345 | 25-6-2020 13:10 |
A | 2019.3 | 346 | 11-11-2020 07:55 |
B | 2019.3 | 244 | 24-9-2020 13:14 |
B | 2020.2 | 243 | 23-12-2020 07:45 |
C | 2019.3 | 456 | 27-11-2019 12:14 |
C | 2020.3 | 457 | 4-12-2020 15:08 |
D | 2019.3 | 567 | 9-10-2020 09:28 |
D | 2020.2 | 569 | 30-12-2020 08:09 |
Desired Dataset
User | Version | Device ID | Last Login | Revoke |
A | 2020.4 | 345 | 25-6-2020 13:10 | |
A | 2019.3 | 346 | 11-11-2020 07:55 | Revoke |
B | 2019.3 | 244 | 24-9-2020 13:14 | Revoke |
B | 2020.2 | 243 | 23-12-2020 07:45 | |
C | 2019.3 | 456 | 27-11-2019 12:14 | Revoke |
C | 2020.3 | 457 | 4-12-2020 15:08 | |
D | 2019.3 | 567 | 9-10-2020 09:28 | Revoke |
D | 2020.2 | 569 | 30-12-2020 08:09 |
Solved! Go to Solution.
Hi @acaryasin01
Here is how you can do it.
Workflow:
1. Sort by user and sort descending on last login.
2. Using mult-row formula tool to flag revoke. If the row is not first row for user flag revoke. This is doesn't flag the latest last login row for user.
Hope this helps : )
Perfect It works, Thank you so much 😊 @atcodedog05
Also Thanks for fast reaction 👍
Happy to help : ) @acaryasin01