Hi All,
I am new to alteryx. I want to parse a json file (saved as .txt) in a folder and update to a access DB.
If it is a single file the update is fine but when I tried with directory input/dynamic input the fields are added as comma separated in a single record in access.
Is there a way I can iterate the workflow for each Record#.
So 1 Record runs and updates the DB and 2nd record runs and updates the DB and so on.
Thanks,
Praveen.
Solved! Go to Solution.
I'm not completely sure on the use-case you have but if you want to build this out and output one file at a time from your directory check out 'batch macro's.
Here's some useful resources to get started. Give these a go and let us know if you need help!
https://www.thedataschool.co.uk/rachel-phang/batch-macros-alteryx/
https://3danim8.wordpress.com/2016/08/09/how-to-use-and-better-understand-alteryx-batch-macros/
Ben