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?
looks like csv with nested json fields. use the json parse on the json fields...
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.
probably doesn't like the [ and ] - give me a second...
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...
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?
