Grouping users

Question

Hi,

I would appreciate your help with the following.

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

IDShortnameEmailOutput123asmithadam.smith@gmail.com1123asmith1adam.smith1@gmail.com1234asmithadam.smith1@gmail.com1567asmith2adam.smith@gmail.com1123asmith2adam.smith3@gmail.com1987dlopezdan.lopez@gmail.com2

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 Answer

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!