Load multiple .json into alteryx (1 file per row)

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.

Input

Accepted answers

danilang

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

All comments

danilang

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

Pingu

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703