Hi
I have a json input that has the following format:
{
"body": {
"1": {
"dataId": 1,
"first": "Mihail",
"address": "Street b"
},
"3": {
"dataId": 3,
"first": "Mickey",
"address": "Street f"
},
"5": {
"dataId": 5,
"first": "Adam",
"address": "Street g"
},
"9": {
"dataId": 1,
"first": "John",
"address": "Street b"
}
}
}
I d like to create a Table from that data as follows (sorry for the ugly Table representation):
| dataID | first | address |
|------------|------------|----------|
| 1 | Mihail | street b |
| 3 | Mickey | street f |
The field names are variable because of the json structure and contain the changing id
Is there a way to make multivalue fields and use mvexpand somehow.
Regards
Chris
... View more