Is it possible to ignore this error seen below? I have almost 200 files I am bringing in and roughly 180 work successfully. I am unable to create an output though because there are issues with the schema of roughly 20 files. Ideally, I would be able to have the workflow ignore the 20 files that don't match and create the output anyway.
Does anyone have suggestions or experience with this?
Could you use a standard input tool with a wildcard input, you appear to want just *2018 files how is this specified? In the file name I guess?
If if you can achieve the desired result using a wildcard in the standard input tools then you get warninings rather than errors which means the workflow will not stop running.
in order to use a standard input tool for such functionality, navigate to one of your 2018 files. You can then replace the dynamic part of the file name with*. Alteryx will then bring in all files that match this style, Only where the schema is identical to the first file read.
so convert c:\desktop\022018.csv to c:\desktop\*2018.csv
My solution for this is a batch macro with the properties set to union all the inputs based on name. You stream all your directory paths to the macro instead of the dynamic input tool, and it just unions each and every input file from the directory paths.