Question regarding blob with JSON files

[android86]

I'm a new user and I recently got a 100's of JSON files which I need to clean for data analysis. I started researching online and found the following video helpful. https://www.youtube.com/watch?v=e5B_jQzCxJ4

However I keep getting following field conversion error and I'm not sure if I'm finding articles which can help me overcome this conversion field error when using blobs. 

In addition to the below fix, how do we join 100's of JSON files into one single JSON file?

[danilang]

Hi @android86 

The error message refers to the fact that the file that you're trying to import isn't a valid json file.  Open the file in notepad and see if it's properly formatted.

To merge the information from all the json files together, you're better off to load all the files and then apply grouping operations based on file name in your workflow.  

1.  Put all the files in a single directory

2.  Use a Directory tool to get the list of file names

3.  Connect the Directory tool to the Blob Input

4.  Configure the Blob input to replace the entire path with Field

The Blob Input will load all the files  one per record.

Dan

[android86]

thank you! Seems like I'm dealing with gz files and I tried to research on forum if converting a lot of gz files into json is possible. I didn't come across anything except this one https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-JSON-gzip-formatted-as-jsonlines...

and a thread from 2016 saying gz wasn't supported. Is that the case?