Latest Activity
Hi, I have a question regarding how to perform an operation in Denodo. I have data in a base view (on a Snowflake data source) that looks like: | Order_number | Icd10_codes | Icd9_codes | | -------- | -------- | -------- | | 1001 | 100.1,101.2 | | | 10...
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
I have a data source that is based on a csv file. This file has a text column that can be pretty long and containg values that are structured as (AC12345) RANDOM TEXT Of VARYING LENGTH. The length of the string betwen the poarentheses are also varying,...
I am basically trying to split the following string in Denodo and trying to create new columns in the database for each value. my_string = ABLMNC_154342_O_UW_UA-UCOU_SMC The problem i am facing is when i split the string, Denodo creates an arra...
I have a string "India (IN)" I only want the country name India removing the delimiters and abbreviation (IN) Split function is not working.
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.