Empty Table in Loop - Send alternative email

[knightyboy]

I can find a bunch of similar topics covered but for the life of me can’t quite find an answer to this specific issue, apologies if I’m just being stupid.

I have a dataset run once a week checking for errors in processing on one of our systems. Each set of relevant errors will need to be emailed to the person responsible for them. If there are no errors found, I want to email the people who don’t have any with a separate email, so they at least know that we’ve checked for them, not that our checks are broken.

One table of data (‘Dummy Data’) and one table of email address that relate to a name field in the dummy data (‘Email Addresses’)

I’ve successfully set up the loop for filtering the data, creating the files (with variable names), and sending out an email to the relevant person, however I can’t seem to quite understand how to use the empty table switch for when there is no data related to that person/email address so that I can create the other email.

I know that I shouldn’t have another Loop End, but I’ve tried End If and connecting it all together and I just can’t quite get it to work.

Appreciate your wise guidance as always.

Many thanks

[Andrew_Steel]

Hi @knightyboy,

you could do it this way:

Best regards
Andrew

[knightyboy]

Not sure that works unfortunately.

I have one table of all the email addresses and one of the data. The data doesn’t necessarily have all the names that appear in the email addresses file, so not sure how that ‘Reference Row Splitter’ is helping things.

Additionally, in that example, the table would never be empty going into the ‘Empty Table Switch’ because it’s not had a variable filter applied to it yet.

[Andrew_Steel]

Hi @knightyboy,

Oh yeah, sorry about that. I have read your request again. Here is another attempt to solve your problem.

I hope it helps.

Best Regards
Andrew
EmailSplitter.knwf (17.7 KB)

[knightyboy]

Ahhh, that’s actually such a simple workaround, thank you!!!