Hi Folks, I have a question regarding running a workflow in Alteryx with null input data. To elaborate, I have 10 File Browse -> Input Data tools in my workflow. However, there may be scenarios where only 3 input files are selected, and the remaining inputs are null. Is there a way to configure the workflow such that the Input Data tools automatically handle null or blank file paths? Specifically, can the file path strings in the Input Data tools be replaced with null/blank values to prevent errors in such cases?
... View more
Good Day dear friends. I have a requirement where I need to send over 1000 emails with different attachments. So basically in one run Alteryx send 1000 emails. I am able to do this if the attachments are same for all the emails, now the ask is to have different excel sheets attached to each email, (1000 different attachments for 1000 emails iterations) Any ideas on how to accomplish this ?
... View more
Hi All: I would like to flag expenses incurred on weekends AND holidays for further review. The excel file I have contained thousands of transactions from 2023 and 2024. The transaction date format I have in my excel file as follow (i.e. 12/11/2023 month/day/year) The formula should also catch the Canadian publics holidays as indicated below: Jan 1 Feb 19 Feb 20 March 29 April 7 May 22 July 1 Sep 4 Oct 9 Dec 31 Record # Transaction date 1 1/1/2023 2 1/1/2024 3 5/4/2024 4 2/19/2023 5 12/25/2023 6 12/31/2024 7 4/5/2024 Thank you in advance for your help
... View more
The first app is running correctly and the 2nd app displays the questions correctly. The 2nd app when running throws the following error: 500 Server Error ServiceData stream ended without being properly closed. I also do not get an entry in the job results in Gallery so even though it does do a portion of the workflow (since it does successfully create an output halfway through the workflow), this error prevents me from seeing what's happening. The 1st app does modify the XML of the 2nd workflow before running it as the chained app.
... View more