uploading json file

Hello,

I'm trying to convert a few thousand json files to a table. I expected this would be easy, but I can't figure it out.

I watched a few tutorials on youtube and tried to find help on this forum, but nothing seems to work for me.

I think my json files have an unusual format or something?

I attached an example file.

What I would ideally like to have is this kind of format (used two first records as example):

created_at	id	id_str	text	display_text_range	...
Tue May 15 11:26:40	996351151313338368	996351151313338368	@RPG_90ROME yaudah bayar berapa nih...	[12,35]	...
Tue May 15 11:26:40	996351151078424577	996351151078424577	RT @EO_ASC: Nah buat yang udah parkir...		...

Any help?

Thanks,

Mikis

upload json.yxzp

Transformation

Accepted answers

BenMoss

I'm not sure why it wasn't reading your .json correctly.

I have ammended your workflow to read the file in as an undelimited .csv file before using the json parse and cross-tab tools to bring the data into the structure you desire.

Check out the solution attached.

Ben

import json.yxzp

All comments

BenMoss

I'm not sure why it wasn't reading your .json correctly.

I have ammended your workflow to read the file in as an undelimited .csv file before using the json parse and cross-tab tools to bring the data into the structure you desire.