I have created a batch macro to extract all the files from a particular folder. Two of the files are not being extracted due to difference in data type for a particular column. I have attached the macro. Anyway we can do this.
Looking forward to an interesting answer. I have already checked the Interface Designer. It is selected to "Auto Configure by Name(Wait Until All Iterations are Run)".
Here you go, attached are the sample files. April FY20 file has a columns named resolved product name, which alteryx is considering as V_String. The same column in September FY21 is being considered as as V_WString.
Just a quick question. In the image that you shared you have taken a single file as input in the macro. I on the other hand was taking all the files. Was I doing it wrong?
@Deba93 If you are doing it all, I guess we dont need the macro after all.😁
On the other hand the batch macro will allow you take in the files one by one, then perform some processing, then union all the results as a final output.
I am unable to open the workflow as these were created in the latest version. My organization currently uses Alteryx designer 2020.3 also I tried providing a single file name as input in the batch macro and ran the workflow. It is reading only that single file and not other files in the directory. Attached is the workflow.
