Latest Activity

code

How to apply text function on field that is used for search method

Hello, I want to apply a text function to a field that is used as query parameter for a base view. The reason for that is because we receive some input parameters (for example a number) and I need to add a prefix. If I receive "12345" I need to add "c...

code

Json array in data set - joining back to original data --- losing records when select * is used

I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...

code

Denodo access cobol file

Hey , please I want to ask if I have cobol copybook file and cobol data file .. is there is way to make denodo read these files and show this data file as relational table in denodo?

code

Can SAP Analytics Cloud use Denodo as a Datasource?

SAP SAC is one of our main reporting front-end tool. Would like to know if Denodo which contains modeled data from multiple sources can be a datasource to SAP Analytics Cloud(SAC).

code

sort response based on specific order

Hi Team, I am developing a denodo odata api by passing filters as entity_id eq 123 or entity_id eq 234 or entity_id eq 124. The response order is different. If I want the response in same order(123, 234,124). Any solution?

code

Issue while starting Denodo solution manager 8.0

Hi team, I have installed solution manager 8.0 in our production linux host today using the install.xml file generated which was explained in unattended installation of olution manager 8.0. License file is copied to the conf folder. But when I start t...

code

com.denodo.solutionmanager.exceptions.ValidationException: Cannot load driver class: oracle.jdbc.OracleDriver

Hi Team, i tried to create 'solution manager database' as mentioned in the below link & got error as 'Cannot load driver class: oracle.jdbc.OracleDriver' https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/configur...

code

Format Odd TEXT Date to Timestamp

I have a field called date that is coming in as text as the following format and I am having trouble converting it to a valid time stamp: 9 - Sep - 2019 19:35 Can anyone help with the formatting of the function?

code

Create a rank in a view

Hi, I have a view created from delimited file with fields bd, date, count and i need create a rank by bd and date. I try ROWNUMBER() OVER ( PARTITION BY ORDER BY _ ) and RANK() OVER ( PARTITION BY ORDER BY ) but it´s nos work. I try case bd when 1 th...

code

Condition based Join of 3 tables

I am having 3 tables - A, B, C. I need 4 kinds of output Case 1 : If condition 1 and 2 both not satisfied : Sel from A Case 2 : If condition 1 satisfies : Sel A. from A Inner Join B Case 3 : If condition 2 satisfies : sel A. from A Inner Join C Case ...