Transposing column headers to rows (post Json unnest)

[jacobcalka]

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

[jacobcalka · Accepted solution]

Nevermind - solved by folding by regex pattern.

[Turribeach]

Please post the solution as well so others can benefit from seeing how you solved it.

[jacobcalka]

Here. Can't share data screenshot due to confidentiality

[Turribeach]

Thanks! That's good enough for people to figure it out.