Hi, I have a WF that pulls down roughly 115,00 records using an API call. Unfortunately, with the limitations, I have to set the throttle records on the Download tool to 150 per minute. Before this job was scheduled, we had set our server config to cancel jobs running longer than 23400 seconds (6.5 hours). In Designer, this WF runs right at around 7 hours. I've tried unchecking the cancel jobs setting, setting it to 36000 seconds (10 hours), setting it to 0 and then unchecking the setting but the job always seems to fail at 6.5 hours. Is there a default timeout somewhere else? Server version: 2024.1
... View more
Hi everyone, We're encountering an issue during the implementation of a workflow and would appreciate your insights. Context: We're pulling data from two tables (MARA and MAKT). Occasionally, one of the two input of the union may be empty. When this happens, the Union tool's output is also empty, and the workflow fails to populate the expected data downstream. We've tried a few workarounds: Using the CacheDataset Macro to materialize the data in Alteryx's cache. However, this requires running the workflow twice, which is not ideal given its complexity and runtime. Disabling AMP engine or using an Action tool to cache the dataset in a temporary folder. Unfortunately, these approaches still result in an empty output unless both input streams to the Union tool are populated. We're looking for a more efficient solution that allows the workflow to handle cases where one of the input tables is empty, without compromising the output or requiring multiple runs. I've attached a screenshot to help illustrate the issue. There are also some try and workaround we tried! Thanks in advance for any suggestions or ideas!
... View more
Hi, I am trying to use the raw xml of an excel file in a workflow, however I am unable to select '[Content_Types].xml'. Selecting just this file results in the error 'You must pick a file from the zip archive', whereas selecting this along with other parts of the excel file results in it being automatically deselected. This happens with all excel files I have tested, as well as when I convert the excel to a .zip before importing. I have attached a sample workflow with my input configurations. Thanks
... View more
Hi we have a dynamic ETL flow , that uses an sql table for a source of where the file will be and what to do with it table structure select Title, LocationOfFiles, Filename, FileType, SqlTableName, DateColumns, IntColumns, FloatColumns, Active, RowColStart, DatabaseName, Region, ID, Locale Healix Accuracy,\\eu974k16mft01\ukrit\Attachments\Healix,Healix Accuracy,CSV,Alteryx_Testing.Accuracy,"Go To Authorisation Date,Result From Authorisation Date","Source ID,User Id","",Yes,"0,0",Sitel_Reporting,UK,1, example of info in table we will have hundreds of records in this table soon - our flow fails if one of the files is not found and we are unsure how to fix this - any suggestions - we have tried a batch macro but cannot get it to configure work correctly
... View more
Hi, Is there a way when new columns come into my workflow, they can automatically update to be a fixed decimal or any type of number field? They are currently coming in as V_String and I was hoping that this would be something I wouldn't have to do manually.
... View more
