I have an entity in the Data Service that contains contact emails. I would like to group all the information of the email “firstname.lastname@example.org” to send all the data by email, do the same for “email@example.com” and so on. Can anyone tell me how I can go about it?
You can use Query Entity Records activity firstly with no filter (or some other specific filter that defines which rows you want to process, eg. column processed = ‘no’ - it all depends on your business scenario) in order to get all rows from data service.
When you have all rows from the entity, by referring to the email field you can get list of unique emails that exist in you entity. Having list of all unique emails, you can query the data service again (Query Entity Records activity) with filter to email field applied.
You can create variable of type list where you would store list of unique email addresses.
Create variable of list type and iterate through the output from Query Entity Records activity. For each item check email address - if it does not belong to the list with emails, append it. Else - omit.