# Flatten Multiple dynamic parameters from mongodb nested json data

**URL:** <https://community.dremio.com/t/flatten-multiple-dynamic-parameters-from-mongodb-nested-json-data/4338>\
**Category:** Dremio University\
**Created:** [October 17, 2019, 11:59am UTC](https://community.dremio.com/t/flatten-multiple-dynamic-parameters-from-mongodb-nested-json-data/4338 "2019-10-17T11:59:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ansuman273](https://avatars.discourse-cdn.com/v4/letter/a/bb73d2/32.png) [@ansuman273](https://community.dremio.com/u/ansuman273)\
**Post date:** [October 17, 2019, 11:59am UTC](https://community.dremio.com/t/flatten-multiple-dynamic-parameters-from-mongodb-nested-json-data/4338/1 "2019-10-17T11:59:50Z")

</div>

Hello Guys,

I have a scenario where I need to create a query for a nested structure data which have data in dynamic keys. Able to extract data for one dynamic parameter by directly flattening on the particular key but need to extract all available . Is there a way to extract dynamic mongoDB json parameters.

Example of json I want to flatten and get data

{  
{“x”:[{“Value”:0}]},  
{“y”:[{“Value”:1}]}  
}