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 have a list of clients that have a single or multiple reports to be attached in each email.
Client A has 2 fullpaths (2 xls file)
Client B has 2 fullpath (2 xls file)
Client C has 1 fullpath (1 xls file)
What I did:
1. Summarize - group by client and concatenate fullpath.
2. Text to column - unconcatenate fullpath by 5 columns (as max reports are 5).
3. Autofield - everything.
4. Dynamic select - Null is represented as boolean. So I uncheck that. This will delete the null columns 3, 4, and 5. I am left with 2 columns: concat_fullpath1 and concat_fullpath2 (second pic below).
5. Email - I added concat_fullpath1 and concat_fullpath2 as attachment. I was thinking if either of the value is null then it probably won't attach anything.
Now client A and B are ok because they have 2 attachments.
Client C is giving the email tool an error because concat_fullpath2 is null.