Forum Discussion
rcyber
8 years agoResolver I
JSON Master-Detail parsing
Hi all!
I have a JSON data that contains a sub-tables. It looks something like that:
"documents":[{
"id" : "1",
"end_date" : "01.07.2018",
"notifications" : [
{
"id" : "n11",
"type" : "First",
"created_date" : "01.07.2018"
},
{
"id" : "n12",
"type" : "Second",
"created_date" : "03.07.2018"
},
{
"id" : "n13",
"type" : "Final",
"created_date" : "10.07.2018"
}
]
},I want to parse it into one flat table with attributes of document. The problem is Power BI parses the Notifications array as list. If I try expand this List then Power BI offers to convert it into rows. But I want to get a new column that will contain the last of Notification date.
Is it possible? How can I do it?
A sample of my JSON data is here.
Thanks in advance,
Alex.
I have solved it by myself.
2 Replies
- rcyberResolver I
I have solved it by myself.
- v-huizhn-msftMicrosoft Employee
Hi rcyber,
Congratulations, you have resolved iy by yourself. Welcome to share your solution and mark your reply as answer, so more people will benefit from here.
Thanks,Angelia