I want to segregate the Mongo DB Data mention below according to the data format mentioned below. I have tried Textbetween() in qlikview but still not able to find proper resolution.
{ "ln" : { "bangla" : 1 }, "conn" : { "2G" : 1 }, "time" : { "10" : 1 }, "np" : { "abp" : 1 }, "cat" : { "latest" : 1 }, "grp" : { "latest" : 1 }, "overall" : 1, "notif" : { "ln" : { "bangla" : 1 }, "conn" : { "2G" : 1 }, "time" : { "10" : 1 }, "np" : { "abp" : 1 }, "cat" : { "latest" : 1 }, "grp" : { "latest" : 1 }, "overall" : 1 } }
| ln | |
|---|
| conn | |
|---|
| time | |
|---|
| np | |
|---|
| cat | |
|---|
| grp | |
|---|
| overall | 1 |
|---|
| notif | | ln | |
|---|
| conn | |
|---|
| time | |
|---|
| np | |
|---|
| cat | |
|---|
| grp | |
|---|
| overall | 1
|
|---|
|
|---|
