Hi all,
I have been searching the community, but could not get workflow to work the way i wanted.
I want to load multiple local .json files into alteryx as text, and each file should be in one cell. I did the same for .xml, but when the files are in .json format Alteryx keeps delimiting the files into separate rows.
Field 1 should contain the whole content of the .json file so each row is one filename. Instead of multiple lines per file.
Currently multiple rows per file, but I would like to have the whole content per file in 1 cell/row.
Solved! Go to Solution.
Hi @Pingu
I can think of 2 ways to do this.
1. Add a summary tool after the Input and concatenate the json rows with filename as key and \n as the delimiter
2. Use a folder browser tool and pass the file names to a Blob Input tool that's configure to output the files as strings
Dan
Thanks Danilang,
1. Seems to work perfectly with removing the , separator! It does the job.
2. Curious for this solution. I am not really familiar with the blob tool, what would be the next step after everything is read in as a blob?
Hi @Pingu
Add a Blob Convert tool after the Blob Input to convert the blob to a string and set the config as follows
"Unicode UTF-8" will probably be the correct code page to use for most json, but you may have to experiment based on your input files
Dan
Thanks Dan!