#DateForumTypeThreadPost
2315 Jul 2015 @ 09:15 PDTDatabaseReplyPivot based on dateIf I read this suggestion correctly, that would end up creating additional columns that would be blank, so that would not satify my requirement.
2210 Jul 2015 @ 08:04 PDTDatabaseReplyPivot based on dateCan anyone give me some direction on how to get the dates (months) to be dynamic in this? I could really use some assistance.   Thanks
2109 Jul 2015 @ 12:20 PDTDatabaseReplyPivot based on date select BILL_NO, CIRCUIT_NO,CYCLE_NO,   max(case when Bill_Month = cast ((cast(ADD_MONTHS (CURRENT_DATE, -3)as format 'mmm'))as char(3))     then MNTH_MRC end) as &qu...
2009 Jul 2015 @ 09:56 PDTDatabaseReplyPivot based on date select BILL_NO,   max(case when Bill_Month ='Apr' then MNTH_MRC end) as April,   max(case when Bill_Month ='May' then MNTH_MRC end) as May,   max(case when Bill_...
1909 Jul 2015 @ 08:43 PDTDatabaseReplyPivot based on dateAny suggestions on the script to use to pivot these dates would be appreciated. Teradata is not my strong suit to any degree.   Thanks for looking  
1809 Jul 2015 @ 07:15 PDTDatabaseReplyPivot based on dateNot really unless the month its self would be used. Of course that would change every month as well since I need to capture the current and pst 2 months. I also have no idea what the count of Bill_...
1708 Jul 2015 @ 11:26 PDTDatabaseReplyPivot based on datei do understand that I will need to use cast((cast Bill_Month as format 'mmm')) as char(3)) as Bill_Month to do the conversion for that part. I am guessing that case may be needed with ran...
1608 Jul 2015 @ 11:13 PDTDatabaseTopicPivot based on dateGood day all, I have data that consists of 3 months of charges for each line item. Bill_No                Bill_Month&nbs...
1515 May 2012 @ 01:53 PDTAnalyticsReplyremove "whitespaces" and "." in a string Thanks ulrich - I saw that you had replyed to a previous post of mine on this issue. I will try this method and respond back soon. Thanks again for looking.
1415 May 2012 @ 01:51 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" Sorry - I got distracted by another issue. Thanks folks - I will check both of these methods and respond back soon.
1314 May 2012 @ 09:42 PDTAnalyticsTopicremove "whitespaces" and "." in a string I have a table with a column of alpha-numeric data the currently has multiple (periods) "." and spaces in the string. I need to remove them for data compare in another DBMS. I ...
1227 Apr 2012 @ 09:54 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" Carlos, Thanks. I wish I could Sanitize the data or use oReplace/oTranslate UDFs - neither of which is an option. So I am left with trying to 'make the best of it' ...
1126 Apr 2012 @ 01:22 PDTAnalyticsTopicQuery with FORMAT'$$$,$$9.99' Not displaying $ as expected. I have a query that runs fine except in my results I am not getting a $ in my currency column. Here is the line I am using: sum(CHRGE_AMT)(FORMAT'$$$,$$9.99') MRC, my results...
1026 Apr 2012 @ 12:43 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" Carlos, I am not sure if my last post made sense or not. Basically what I am seeing in my data is for my part 4 the data either appears as: 123.A1.ABCDEFGHIJK.ABCDEFGHIJK 99.ABDC...
926 Apr 2012 @ 10:41 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" I tried the wrapping, but to no avail. I received the error: [Teradata Database] [3706] Syntax error: expected something between '(' and the 'SELECT' keyword. I suspect t...
826 Apr 2012 @ 09:20 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" I will try the wrapping. I found a couple instance where I am getting TERADATA SUBSTR: string subscript out of bounds. So it looks as though the inconsistent formating is going to cause some...
726 Apr 2012 @ 08:24 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" Carlos Thanks for your follow up! I appreciate your patience with the newbie. What it boils down to then is that I did not know how to apply this to my existing query. After playing with it ...
626 Apr 2012 @ 06:58 PDTDatabaseReplyQuery SUM then Total within the same query Dieter, This was exactly what I was in need of: If you need it as a new column it's an OLAP function: SUM(Sum(CHRGE_AMT)) OVER () by limiting my GROUP BY TO BILLING_NO, BILL_MO...
526 Apr 2012 @ 06:02 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" Dieter, I need the change everytime the query runs. Primarily because this will end up being part of a cross-query against an Oracle query that will depend on the account_no being formated w...
425 Apr 2012 @ 04:46 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" Anyone have any suggestions or thoughts on how to accomplish this? I appreciate your time and thanks for looking.   Gmoney
325 Apr 2012 @ 02:00 PDTDatabaseTopicQuery SUM then Total within the same query I have a table of data that I am query against with the following columns: BILLING_NO BILL_MONTH_DT  BILL_CYCLE_DT  CHRGE_AMT ACCOUNT_NO. The BILLING_NO is the ...
225 Apr 2012 @ 01:26 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" I just checked - nothing there.
125 Apr 2012 @ 07:49 PDTDatabaseTopicChange all periods "." in a column to forward slash "/" I am running a query that returns blling data with an account number that contains "." in no set position. What I need to do is replace the period "." in each instance t...