You can translate the question and the replies:

Flatten view

Hi Team, I have created one view from Json data source.In this view there are multiple columns and 4-5 coloumns are itself a collection of array.And Inside these element array there are elements which are itself a collection of array. I want to flatten it.I right clicked on View ->New->Flatten.Then I clicked Flatten array on element which I need to create.Flatten view are getting created but along with rest of the coloumn which are array type. I want to create seperate view of each coloumns which are array type along with common coloumn which are not array type. Please help here. Thanks in Advance. Regards, Neetu
user
29-09-2020 06:17:30 -0400

1 Answer

Hello, I was able to create a separate view of one coloumn which is array type along with common coloumns which are not array type by [creating a selection view](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_selection_views/creating_selection_views) over the flattened view and by removing the columns which are not needed in the 'output' tab. Repeat the process to create separate views for the remaning arrays. I was able to flatten multiple arrays by repeating the ['flattening'](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_flatten_views/creating_flatten_views) operation for each array as it is possible to select just one array on each 'flattening' operation. If you still need help and if you are a user with valid support access then you can raise a support case in Denodo Support Site so that our support team can help you. Hope this helps!
Denodo Team
29-09-2020 16:27:53 -0400
You must sign in to add an answer. If you do not have an account, you can register here