Forum Discussion

rcyber's avatar
rcyber
Resolver I
8 years ago
Solved

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.

 

2 Replies

    • v-huizhn-msft's avatar
      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