Forum Discussion
rcyber
Resolver I
8 years agoJSON 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
- rcyber
Resolver I
I have solved it by myself.
- v-huizhn-msft
Microsoft 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