This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to figure out how to trigger the delivery of an email in the specific case in which a String value is not found in my field. The email is pretty much supposed to be sent to me on a daily basis only to notify "hey, that string today is not there".
Any idea on how I can trigger the email in such case?
If I understand correctly, the MODULE field has multiple strings and you want to check if any of them contains "Tableau". If none of them do, you want to send the email. So there will always be some records that do not match.
This will do it:
Count the records from the true anchor on your original filter, and check if the count is 0 (no matching strings). Connect the email tool to the T anchor on the second filter.
If you also want to identify which records and associated values do not match your requirement (equal to Tableau), try appending text to a table containing the invalid records using the Report Text tool, then attach to your Email tool with the Table field as your message body.
Let me know if you want the workflow to stop processing downstream if any MODULE values do not equal Tableau.
I think you mean you might have the following dataset:
and you want an email to be sent if "Tableau" does not appear in the "Module" column at all. So, you only want to receive one email, basically saying it does not exist.
I've achieved this as follows:
I used the Summarise tool to concatenate the Module column into a single cell, separated by \n (line breaks). This allows you to then filter on whether the entire column contains "Tableau" or not, and not individual rows.