0 - 18 of 18 tags for concatenate

Hi,
I have a table that looks like this:

Column1 Column2 Column3
800 900 200
500 300 40
100 600 150

and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:

Result
200,800,900
40,300,500
100,150,600

Hi,

I have a table that looks like this:

 

Column1 Column2 Column3

800        900        200

500        300        40

100        600        150

 

and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:

 

Result

Hi,

I have a table that looks like this:

 

Column1 Column2 Column3

800        900        200

500        300        40

100        600        150

 

and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:

 

Result

I'm looking into usage of function: tdstats.udfconcat. Is there any way to control the order of the values that this function concatenates?
If I have a table: TABLE1 that looks like this:
Column_A               Column_B
55555                     123
55555                     124
55555                     125

Hello
Using version 15, I am stuck with 3707 error:
[5526] SPL1027:E(L417), Missing/Invalid SQL statement'E(3707):Syntax error, expected something like an 'END' keyword between ';' and the 'with' keyword.'.
Line 417 is the termination semicolon for a recursive query trying to concatenate a field:

Hi There,
i need help to write an sql script to return values from different positions within the example string below:
#12345678.#98B9876.#123456
i want values from positions 2-8 and concatenate with values in positions 11-13.

Hi,
I've been struggling to get the following piece of code to work - is there no way to get the working select statement below (See comment ** Working **) to work within a view?

I am trying to create new variables using a combination of text and numbers. I thought this was possible but do not know for sure. I am getting the following error dont know if its because im missing something simple or the way im trying to concatenate is fundementally incorrect. The query ran exactly as desired prior to adding the concatenated fields.

Hi everyone,
I need to load a column that is a concatenation from two fields of a file. One field is a date other is time type. I would like to load both resulting in a timestamp field but i wanted to do it during the tpt load. Is it possible? How can i concatenate two fields in the insert statetment?

Hi Guys,
 
I am brand new to Teradata and writing advanced queries (with data munipulation).  I just got out of school.

Hello,
This question is a spinoff of the following thread:
http://forums.teradata.com/forum/database/concatenate-value-of-multiple-rows-into-one-single-row-1#comment-133576

Greetings,
I am attempting to rank entires in a table, but want the rank to start over with each new value in the ID field.  The idea is to create a unique identifier out of the NAME and the ranking which is based on the number of lines of each ID value.  See example below...
Here is the source data:

I have a query that results in data containing customer id numbers, marketing channel, timestamp. So, the results might look something like this.

So, I'm not sure why this statement isn't working properly.

MERGE INTO table1 as a
USING table2 as b
ON a.date = b.date AND a.id = b.id
WHEN MATCHED THEN
UPDATE SET col2 = CAST(a.col2 as VARCHAR(3)) ||','|| CAST(b.col2 as VARCHAR(3))
WHEN NOT MATCHED THEN
INSERT (id, col2, date)
VALUES (b.id, b.col2, b.date);

 

How do I combine multiple Select queries?

I have 7 queries run separately. Each query return 2 columns. Count(of something), (date)

Date Range is Fixed for each query Set to 1 Week only.

Good Afternoon,

My question is this what I want to do is to a date depending on the month to add the last day of the month.

For example I get:

I've had some problems with joining to a concatenated variable and although I've fixed the problem I'd like to understand what happened here.

As background, in a transaction table we have the first digit of the account number was dropped for a couple of days and so we have a number of records where the account number needs a single digit added to the front.

We basically wanted to do a really simple query to find out how many transactions have been made on an account. However, when a join on the reconstructed account number didn't work.

The abstraction of the code is below: