You can translate the question and the replies:

Convert CSV into rows without the use of SPLIT function

Hi experts, Looking for alternative ways of converting comma separated values into rows without using the SPLIT/FLATTEN function as we want to delegate this completely to an oracle source. Please let me know if any ideas. Thanks.
user
06-01-2021 16:06:31 -0500

1 Answer

Hi, I can think of the following ways as a possible solution for your requirement. 1. Using SELECT/UNION statement described in this article:[How to Pivot and Unpivot Views](https://community.denodo.com/kb/view/document/How%20to%20Pivot%20and%20Unpivot%20views) 2. You can try to create a base view from a query if you know the query that realizes your requirement in Oracle I found this info in the following manual. This should be helpful to you. * [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) Hope this helps!
Denodo Team
07-01-2021 02:08:55 -0500
You must sign in to add an answer. If you do not have an account, you can register here