Iterate each filed and update to Access Database

[praveenpurush]

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.

[BenMoss · Accepted 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