Group Rows by Email in Table: Merging Strategies Explained

How do you do a Group by on rows in a table by an email? I.e. merge all rows that have the same email

· Sorted by Oldest

Asher
·
·
Hey Shayan H. , if you want to avoid deduplicating, I would recommend the following.
1.
Push all email to a new table.
2.
In the new table, do a deduplication
3.
Now you have unique email address
4.
Lastly, do a ‘look up multiple rows’, and match the email addresses to multiple rows in the previous table
That might be the closest you can get to a ‘Group By’ in Clay
Shayan H.
·
·
her eit is! https://app.clay.com/workspaces/533071/workbooks/wb_0sxypoiuvDum7FX3Dit/tables/t_0sxypoupCtcPZUB35e7/views/gv_0sxypouASxh7YHBGbod

Asher
·
·
Hey Shayan H. , if you want to avoid deduplicating, I would recommend the following.
1.
Push all email to a new table.
2.
In the new table, do a deduplication
3.
Now you have unique email address
4.
Lastly, do a ‘look up multiple rows’, and match the email addresses to multiple rows in the previous table
That might be the closest you can get to a ‘Group By’ in Clay
Shayan H.
·
·
her eit is! https://app.clay.com/workspaces/533071/workbooks/wb_0sxypoiuvDum7FX3Dit/tables/t_0sxypoupCtcPZUB35e7/views/gv_0sxypouASxh7YHBGbod