Row string to column header and corresponding value

[RTAlteryx_2404]

Hello All,

I have a column that has the data I require including header and value.

{"customerFullName":"ABC","customerCode":"Claim","StatusCode":"Guided","TypeCode":"VST","ProcessName":"Servicing "}

I want to have customerFullName as column header and ABC as its value, so on and so forth

So My data is arranged like Table 1 in the attachment and I want it to be like Table 2. What tool should I be using? Any examples would be highly appreciated.

[PhilipMannering · Accepted solution]

Hi @RTAlteryx_2404 

You can use the JSON Parse Tool and then Cross tab the result,

[RTAlteryx_2404]

Thank you Philip. Will definitely look at it and let you know

[RTAlteryx_2404]

Awesome Philip. It worked like magic