JSON Master-Detail parsing

[rcyber]

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.

[rcyber · Accepted solution]

I have solved it by myself.

[v-huizhn-msft]

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