Sorry for the new topic, but I felt that thanks to advice from @ovi my question has changed accordingly.

I currently have 2 data tables.

DT_1 is just 1 column and a list of unique names =

Fred

Zak

Mike

DT_2 contains many entrys per name =

Name day

Zak Monday

Zak Tuesday

Fred Monday

Fred Friday

Mike sunday

Mike Monday

What I am struggling to achieve, is I want to split DT_2 according to DT_1

So what I end up with is a DT_3 for each name.

my logic on how to achieve this is =

For each row in DT_1

For each row in DT_2

If DT_2 row = DT_1 row

then

Add row to DT_3

email DT_3

Clean DT_3

Continue

is my logic correct ? will this add each row for “Zak” to a single DT, email it, clean the DT , and then add each row for “Fred” and so on?

And if my logic is correct, then I have been struggling all evening on implementing it. Would anyone know the syntax for the “If” activity ?

Thank you for reading