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.
If Field 1 or Field 2 or Field 3 is empty, I would want the entire row of data to be added to the excel output for that company. Multiple sub-companies within the same company should be included in the same excel output, but on a different sheet.
The outputs should be included as attachments (1 per email) to the designated steward for that company, with their email address included in the data.
I should note that some companies have multiple stewards, so multiple email addresses are required. Could this be handled as well? I am including an example in the mock data.
So after a bit more digging, I solved the Email error. I (idiotically) forgot to populate the "From" address. I thought the tool was trying to tell me that there were no records being fed into it (when there clearly were).
As such, my only issue now is the overwriting of the output files. Any instance where I wanted multiple sheets for a single company results in the last written output to be the only sheet that exists within that file name.
Another update: it seems like I have solved my previous issue by switching the Output Option to "Overwrite Sheet".
This solves all existing problems; however, it creates another. Depending on the run, I sometime get an error about a file being used by another process (obviously this occurs when a new sheet is trying to be written to a file that isn't quite finished writing its previous sheet).
It seems like a Block Until Done tool would be of use in this scenario, but I don't quite understand how to implement it properly (ie. without using filters to identify every case where multiple sheets are written to the same file).
Do you have some sample data ? (even a list of company/subcompany codes) I added some more records to your data and I can't emulate the error. I have seen this error before, but I haven't run across it for a while (I think the more recent versions of Alteryx handle it better).
Also, please consider marking one of the replies as a solution to this problem :)