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
19 - Altair

 

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