#DateForumTypeThreadPost
503 Jun 2014 @ 11:52 PDTDatabaseReplyconcatenate value of multiple rows into one Single rowI have moved my question above to a new thread: http://forums.teradata.com/forum/database/concatenate-values-from-one-field-in-multiple-rows-into-one-one-field-on-all-rows Thanks!
403 Jun 2014 @ 06:21 PDTDatabaseTopicConcatenate values from one field in multiple rows into one one field on all rowsHello, 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 I have been utilizin...
302 Jun 2014 @ 02:26 PDTDatabaseReplyconcatenate value of multiple rows into one Single rowHello, I have been utilizing the code provided by Dieter (works great), but I have a slight variation on the original question.  How would Dieter's code change if we wanted to concatenate...
202 Jun 2014 @ 09:37 PDTDatabaseReplyUse RANK (or other funtion) to number duplicate values in a field, start over with each new field valueThank you, Santanu! The code worked, except I have cases where there are more than 9 records with a given ID, so I updated the code for the new field to look like this in order to maintain the 3-c...
130 May 2014 @ 02:44 PDTDatabaseTopicUse RANK (or other funtion) to number duplicate values in a field, start over with each new field valueGreetings, 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 ...