Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to run a workflow one excel cell at a time?

devalex
5 - Atom

I have an alteryx workflow that takes that takes a piece of JSON code and deciphers the JSON code into a readable table. The problem I have is that I've been having to manually put each JSON code into the workflow, but I have hundreds of JSONs that I need to convert.

How can I simply link an excel column with all the JSONS put into their own cells and have alteryx go down, one by one on each cell and output the converted JSONs into one table and distinguish them with a custom ID column?

2 REPLIES 2
apathetichell
20 - Arcturus

 

read in your json excel file normally. attach a record id tool. group by your new record id tool.  if needed turn current workflow into a macro and run each record id individually.

Labels
Top Solution Authors