[SOLVED] Convert Json with array of arrays to columns in Sql server

Issue I have the json (example) below: ‘{"X":["x1","x2","x3"],"Y":["y1","y2","y3"],"Z":[["x1y1","x1y2","x1y3"],["x2y1","x2y2","x2y3"],["x3y1","x3y2","x3y3"],["x4y1","x4y2","x4y3"],["x5y1","x5y2","x5y3"]]}’ (the true json has numbers, but for the example i am using strings) It represents values in tree dimentions (X,Y,Z) I would like to convert that json into columns, like the table

Continue reading