Grouping users

[nikadomi]

Hi,

I would appreciate your help with the following.

I need to group users using three fields. Here is an example:

ID	Shortname	Email	Output
123	asmith	adam.smith@gmail.com	1
123	asmith1	adam.smith1@gmail.com	1
234	asmith	adam.smith1@gmail.com	1
567	asmith2	adam.smith@gmail.com	1
123	asmith2	adam.smith3@gmail.com	1
987	dlopez	dan.lopez@gmail.com	2

I know that first 5 records belong to one employee (wither by ID, Shortname or Email). My goal is to get a column "Output". Basically my aim is to get information which IDs, Shortnames and Emails are associated with the same employee.

Thank you a lot for your help!

[jamielaird · Accepted solution]

Hi @nikadomi ,

Here's one approach you can take. I've included annotations to show what's going on at each step. One modification you might want to make is to re-number the groups but I've left this on the default value to avoid overcomplicating the workflow.

-----

If I've answered your question please consider marking this solution as accepted. Thank you!

[nikadomi]

Thank you soooo much!