Converting multiple .csv files with JSON text into usable data

Question

I was hoping for some help for an activity that I am working on, specifically the Escaping the Digital Dungeon activity created by E&Y. I currently have 53 .csv files on excel that I managed to pull into Alteryx using the directory tool. These files all contain JSON text, and I need to sort through the data contained on them. I can view this data if I open the files individually with notepad, but aren't sure how to put all of them into alteryx so I can use the data cleaning tool. Any help would be really appreciated!

apathetichell · Answer

@psanchez follow these instructions - and post if you are having more issues. Sounds like a fun project. I personally never use dynamic input (as used by @jdminton ) - but if it works - it works.

jdminton · Answer

@Qiu is correct. I added a couple of extra tools to make the data more like how you probably want it. I also added the requirement of multiple file input you were needing. You will need to point the directory to your dataset location.

Json Parse.yxzp

Qiu · Answer

@psanchez

I import the file as CSV with 	 (Tab) as delimter then a JSON Parse tool can parse it without any issue.

0405-psanchez.yxmd