This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a .csv with nested JSON rows that I would like to break into columns. I have been following steps from a similar posting from earlier this year, which have me close to my goal.
An example input row looks like the following (formatted here for legibility):
... and it continues
My workflow gets me to this point so far:
This is close to what I want to achieve - something like this:
(important that the recordID be preserved)
What is an efficient way to achieve this final outcome? Workflow attached.
Any and all help/suggestions greatly appreciated.
Go to Solution.
Go to Solution.
The workflow you sent didn't include the text file you were working from, so I have built the solution from where you got to...
Low (3/4 in. to 1 1/2 in.),Leather,Women,7,7,Black,FAWNA-BLKMUL,Oxfords,FAWNA-BLKMUL,Marc Fisher,Adult,B(M)
The format you want the data in doesn't work particularly well because as you can see the 'key' changes for each record ID. I have got it in the format you want but it still shows a lot of blanks.
Hope this helps.
Thank you for the response and solution. I recently came to very similar conclusion (admittedly with a few extra steps).
There are quite a few empty spaces with the format that the data is in; for the time, that will be a separate issue -- happy now to have it in a more machine-readable format.
I have posted my workflow below as a reference for others if they want a similar approach.
Many thanks (text file to be included next time),