Forum Discussion
Anonymous
4 years agoNot applicable
get Json array and generate rows and columns
Got this json array in a column but need to separate its positions by multiple columns and rows [{'from': 200000, 'until': 700000, 'value': 40000}, {'from': 700001, 'until': 1200000, 'value': 60000}...
Greg_Deckler
Community Champion
4 years agoAnonymous So, dumb question, but is this coming from a JSON file? Because something like this works fine when importing via JSON connection.
{
"_id": "61f872",
"studyvalue": [{"from": 200000, "until": 700000, "value": 40000}, {"from": 700001, "until": 1200000, "value": 60000}, {"from": 1200001, "until": 11999999, "value": 80000}, {"from": 12000000, "until": -1, "value": 120000}],
"paymentpercentage": "7"
}
Otherwise I believe you will need to use Json.FromValue:
Json.FromValue - PowerQuery M | Microsoft Docs
Anonymous
4 years agoNot applicable
I'm getting the data directly from a MongoDB Database collection, via Python script