THe Movies Dataset: How to parse it?

[JohnMaty]

Hi Everyone,

I downloaded this dataset.  The Movies Dataset | Kaggle

I cant figure out how to parse it in Altreryx.  I attached a smaller file from the set to this.  Can someone help me out?

[apathetichell]

looks like csv with nested json fields. use the json parse on the json fields...

[JohnMaty]

It get nothing when I try a JSON parse.

Just an error.

ConvError: JSON Parse (4): Parse Error in Record [{'id': 16, 'name': 'Animation'}, {'id': 35, 'name': 'Comedy'}, : Error message: Missing a name for object member. at character position: 2

Sorry this is very new to me.

[apathetichell]

probably doesn't like the [ and ] - give me a second...

[apathetichell]

tracked it down... Alteryx doesn't like ' vs " in JSON. If you swap this out it should be fine with the JSON parse tool. You'll still need to do additional cleaning...

[apathetichell]

Hi - can you mark this as correct - that way the next person who is trying to solve why the json parse tool isn't working can stumble upon the issue with single quotes versus double quotes?