If this wasn’t the case, I would suggest the Pivot snap. But, since it is, I think you’ll need to use an expression like the following:
$.entries().map(col => { Category: col[0], DataType: col[1] })
The entries()
method will return a list of all the properties in the input document as pairs. The .map()
method and callback then turn the pairs into their own objects. You can then follow up with a JSONSplitter to turn the array output by that expression into a series of documents.
Here’s an example pipeline that does that:
PivotProperties_2019_09_16.slp (6.9 KB)