You can translate the question and the replies:

Split a column into different rows where value for the column is a list of strings.

There is a view a with one column value as ['avc','ghy']. How do I split these value in different rows? Output should be like avc ghy
user
14-12-2022 04:09:15 -0500
code

1 Answer

Hi, If I want to split a comma-separated column value into multiple rows, I would create a [Selection](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/creating_selection_views/creating_selection_views#creating-selection-views) view over the view containing this column. Then, I would perform a [Split](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/text_functions/text_functions#split) function for the particular field. On doing this, an array with this values will be created. You could then make use of the [Flatten](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/creating_flatten_views/creating_flatten_views#creating-flatten-views) operation to place these values into multiple rows. In addition, you could take a look at the similar [Q&A](https://community.denodo.com/answers/question/details?questionId=9060g000000kB0sAAE&title=Split+Comma+separated+string+to+rows) for more information. Hope this helps!
Denodo Team
14-12-2022 07:39:17 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here