Q&A BY TAG 'concatenate'

You must sign in to ask a question. If you do not have an account, you can register here

Problems in converting oracle math operation and the concatenation operator
answered 09-02-2022 04:57:35 -0500

Hi support team, I'm having trouble putting this query into my view WHERE CONDITIONS, there is an AND Operators in front of the line This is my original query from oracle ... AND datedata+(8/24)>=todate(tochar((sysdate+16/24)-1,'YYYY-MM-DD')|| '00...

Answers: 1

Date Conversion concatenate Oracle

Denodo GraphQL - Concat field or output manupulation
answered 20-09-2021 08:31:34 -0400

Hi, I have a question on Denodo GraphQL. Is there a way to concat two values in a graphql query or have calculated fields like its supported in Restful Web services. Like example below query transactionsview(uid: 'abcd') { uid transname transid qty pr...

Answers: 1

concatenate GraphQL

How to add a trailing 0 to number
answered 13-05-2021 11:23:44 -0400

Hello, I have month and day in this format 1,2,3... how can I convert it to 01,02,03, ... Thank you

Answers: 2


concatenate rows - same column
answered 18-11-2020 00:38:46 -0500

Hello, I am trying to concatenate data from the same column but on different rows for the same record. The column in question is one that contains notes and what I need to do is combine notes. Below is an example of what I am looking to do. TABLE ID S...

Answers: 6


Combining rows
answered 25-07-2019 07:54:45 -0400

We have pulled in data from JIRA using the api as a datasource. After flattening out all of the data, I am seeing duplicate rows with the same ID field, but one column has different values. I'm attempting to combine those values so I only see one entry...

Answers: 1