#DateForumTypeThreadPost
801 Apr 2016 @ 02:48 PDTDatabaseTopicStripping RTF new line values from fieldHi all, I have a field that is a varchar(10000) which contains the ¶ symbol when I select from it. It seems I don't have access to the otranslate function (SELECT Failed. 5589: Funct...
715 Oct 2015 @ 02:03 PDTDatabaseReplyquery to bring in multiple row values into one recordThank you! The next time I get some dev time, I will be playing with this. Its greatly appreciated.
615 Oct 2015 @ 09:41 PDTDatabaseReplyquery to bring in multiple row values into one record One last question, My source data has duplicate "line" numbers. There is a column which has a flag in it, so we can see something like the following: ID | Line | Name | Flag ...
515 Oct 2015 @ 08:48 PDTDatabaseReplyquery to bring in multiple row values into one recordThis was my issue: QUALIFY RANK() OVER(PARTITION BY claim ORDER BY line_num asc) = 1; I had asc instead of desc, now I'm concatenating properly, but there are still some duplicate claim id re...
415 Oct 2015 @ 08:39 PDTDatabaseReplyquery to bring in multiple row values into one recordHi Dieter, thanks for the reply. I'm using teradata to query against an Epic Clarity database and do not have the permissions to determine versioning. However, when I ran the select statement y...
314 Oct 2015 @ 03:22 PDTDatabaseReplyquery to bring in multiple row values into one recordThis is my actual code:   create volatile table eob_test as ( select ap.claim_id, cl.mnemonic , ap.line from ap_claim_eob_code ap left outer join clarity_eob_code cl on ap.eob_code_id ...
214 Oct 2015 @ 01:27 PDTDatabaseTopicPartial string matching requires character operandsHi all, I've got an interesting issue going on with Teradata. Suppose I have a table tbl with columns col1, col2, col3 with col1 being the primary key. I can run  Select * from tbl wh...
114 Oct 2015 @ 09:56 PDTDatabaseTopicquery to bring in multiple row values into one recordMy data looks something like this: table1: ID | Line | Code 1 | 1 | a 1 | 2 | b 2 | 1 | d 2 | 2 | e 2 | 3 | f   table2: Code | Name a | alpha b | beta d | delta e | epsilon f | ...