0 - 12 of 12 tags for partition by

I've a data in the following format  -
cust_name , month, isAccountActive
A, jan-15, 1
A, feb-15, 1
A, mar-15, 0
A, apr-15 , 1
A,  may-15, 0
B, jan -15, 0
B, feb-15,1
B, mar-15,1
B, apr-15, 1
 
My output should look like follows-

Hi, I realize you can't do a count distinct with partition by so I'm looking for a workaround. How do I combine the 2 tables to give me the result table? Thank you!

Hi, 
I realize you can't do a count distinct with partition by so I'm looking for a workaround. How do I combine the 2 tables to give me the result table? Thank you!

Hello,
I have a table with Customer, Quarter, Month and Sales (montly) figures.
I need to calculate Quarter Sales and Previous Quarter Sales per Customer, while also showing Montly sales (see desired table format below).
For quarter sales I use sum() over partition by

Hi, this is my first post
I'm a beginner in Aster (nCluster v.6.0.1.00) and I am interested in using R scripts.

I have a situation where I need to do the following:
I have the below information

Hi, I have the following data and I am trying to find a way to identify the rank of the default event for each account. For example, when Default_Event = 1 it means it is a continuous default. So, per the data, the first default event started in 201001 and lasted till 201002, the second default event started in 201005 and lasted till 201006.
 

Hi,

 

I am new to Teradata and I am working on query for which I greatly appreciate any help.

 

i have data in a table as shown below:

 

date

id

value

1-Jan-13

1

100

2-Jan-13

1

100

3-Jan-13

I have data  as follows in a Table ( 3 columns ):

I am not positive this is a sliding window problem, but it is my best guess. I would like to show the current rows values and the next row, on the same output record, and then advance to the next recor --, repeat.

I'm looking to rank the number of a specific call based on the volume of calls that precede it within a 30 day window prior to the current call.  The challenge ... I am ranking calls over a long period of time so the 30 day predeing window is not fixed.  Essentially it is a running total count on a 30 day rolling window.

Hi,

i have data:

select JOB,NAME,CODE,START_TM from table TableT

JOB,NAME,CODE,START_TM

-------------------

JOBA,M,S,2010-06-04

JOBB,M,K,2010-06-05

JOBC,N,A,2010-06-02

JOBD,N,A,2010-06-03

JOBE,O,A,2010-06-04