Do you mean a link? If so:
https://www.easydatatransform.com/Just as an example of the tree<->table issue:
If you input this JSON tree:
{
"Color": "Blue",
"Part": [
{
"Type": "A",
"Number": [
"1",
"2"
]
},
{
"Type": "B",
"Number": [
"1"
]
}
]
It can be converted to a table as:
Color,Part.Type,Part.Number
Blue,A,1
Blue,A,2
Blue,B,1
Which is fine is you then want to output as Excel, CSV etc. But if you then output that back to JSON you get:
[
{
"Color": "Blue",
"Part": {
"Type": "A",
"Number": "1"
}
},
{
"Color": "Blue",
"Part": {
"Type": "A",
"Number": "2"
}
},
{
"Color": "Blue",
"Part": {
"Type": "B",
"Number": "1"
}
}
]
Which is conceptually equivalent, but less compact (similarly for XML). I am hoping to fix this issue. But if anyone has any links to how to unflatten a table into a compact tree, I'm all ears.
