I have attached a file which is Survey response file.
Similar to this I have 100 company response files and I want to extract it in a desired format and then analyse it.
I have prepared the workflow for extracting it in the desired format but I need help with preparing a macro so that I could run all 100 responses together and all 100 files together in a single file or multiple files but at one go.
Thank you in advance.
Solved! Go to Solution.
@pranit1997
I have created a standard Macro to read all the files and the processing part is from your workflow.
so only input and out are mine.
@pranit1997 , try this.
add a formula tool and use this
[FullPath]+"|||SG&A data and activity drivers" in formula tool and it will work.
Thanks.
Hi
facing this error:
Was not able check your solution as alteryx versions are not matching
Hi @pranit1997 , the schema of the file might be different can you check the fourth file that you are trying to parse?
Try to run this particular file in the macro and check if the fields are getting changed?
Note: The schema should be same for all the files.
Thanks.
Hi @pranit1997 , change the text with the path where your files are located just need to provide one path.
Also attaching the latest macro that you can replace with the older one and then edit the path.
Thanks.
@pranit1997 , I am glad this worked for you. Thanks for marking my posts.
Thanks and Have a great weekend ahead!
Thanks for your help.
1) I made copies of both the workflow in a different folder.
2) In Workflow test business & operations - I have made changes in this one by creation a copy of this workflow.
3) Then I saved it and I am trying to run the 2nd workflow for running the macro i.e. capture company response but the output that is coming from the 2nd workflow is not catching the updated version of Workflow test business & Operations.