You can translate the question and the replies:

Denodo function to expand table column

Hello. Does Denodo have a function to expand table columns similar to this one? https://learn.microsoft.com/en-us/powerquery-m/table-expandtablecolumn Thank you!
#expandtablecolumn
user
16-01-2023 11:55:13 -0500
code

2 Answers

Hi, The Denodo Platform has the ability to model data types with a complex structure like registers and arrays. For arrays, find your view that contains the complex structure, create a new flatten view, and choose the array you want flattened. You can refer to [Creating Flatten Views](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/creating_flatten_views/creating_flatten_views) in the **Virtual DataPort Administration Guide** for more information. The function you are asking about could also describe an association which is a representation of two views and defined by two endpoints and a list of mappings. Each endpoint is associated with a view and has a 'role name', description and multiplicity. Meanwhile, a list of mappings defines the relations between the fields of the two views and allows traversing of the association. You can refer to [Associations](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/restful_architecture/associations/associations#associations) in the **Virtual DataPort Administration Guide** for more information. Hope this helps!
Denodo Team
18-01-2023 21:08:26 -0500
code
Hi, The Denodo Platform has the ability to model data types with a complex structure like registers and arrays. For arrays, find your view that contains the complex structure, create a new flatten view, and choose the array you want flattened. You can refer to [Creating Flatten Views](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/creating_flatten_views/creating_flatten_views) in the **Virtual DataPort Administration Guide** for more information. The function you are asking about could also describe an association which is a representation of two views and defined by two endpoints and a list of mappings. Each endpoint is associated with a view and has a 'role name', description and multiplicity. Meanwhile, a list of mappings defines the relations between the fields of the two views and allows traversing of the association. You can refer to [Associations](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/restful_architecture/associations/associations#associations) in the **Virtual DataPort Administration Guide** for more information. Hope this helps!
Denodo Team
18-01-2023 21:08:45 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here