Transposing column headers to rows (post Json unnest)
![jacobcalka](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar10.png)
Hi,
I am doing work with getting data from api's and parsing/manipulating it. I have connected to the api source via the api connect plug-in and I have parsed the json via the unnest object recipe. Unfortunately, instead of outputting two columns such as Json_name and Json_value, it puts all the Json names as columns with all the values in the rows, leaving me with thousands and thousands of columns and one row with the names as the headers. Looking for a transpose tool where I can select every column header. Don't know of anything in dataiku that can do this. I am aware of the tools where you have to manually select all the columns. Let me know. I've included the data with the top row being the column headers and the only row in the table being the values for each json_name. Thank you
api_response json_name1 json_name2 json_name3 ...
long json phrase json_value1 json_value2 json_value3 ...
Operating system used: Windows
Best Answer
-
Nevermind - solved by folding by regex pattern.
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,876 Neuron
Please post the solution as well so others can benefit from seeing how you solved it.
-
Here. Can't share data screenshot due to confidentiality
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,876 Neuron
Thanks! That's good enough for people to figure it out.