# | Date | Forum | Type | Thread | Post |
8 | 01 Apr 2016 @ 02:48 PDT | Database | Topic | Stripping RTF new line values from field | Hi 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... |
7 | 15 Oct 2015 @ 02:03 PDT | Database | Reply | query to bring in multiple row values into one record | Thank you! The next time I get some dev time, I will be playing with this. Its greatly appreciated.
|
6 | 15 Oct 2015 @ 09:41 PDT | Database | Reply | query 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
... |
5 | 15 Oct 2015 @ 08:48 PDT | Database | Reply | query to bring in multiple row values into one record | This 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... |
4 | 15 Oct 2015 @ 08:39 PDT | Database | Reply | query to bring in multiple row values into one record | Hi 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... |
3 | 14 Oct 2015 @ 03:22 PDT | Database | Reply | query to bring in multiple row values into one record | This 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 ... |
2 | 14 Oct 2015 @ 01:27 PDT | Database | Topic | Partial string matching requires character operands | Hi 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... |
1 | 14 Oct 2015 @ 09:56 PDT | Database | Topic | query to bring in multiple row values into one record | My 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 | ... |
|
|