Counting customers in LOAD Script

[ecabanas]

Hi,

I'm loading the full table of sales, but I want to create another one to know the number of customers per month.

Custaccount	created_at	SalesBOid
C000001	1/3/2011	PV00160319
C000002	7/4/2011	PV00160333
C000002	31/5/2011	PV00160368
C000000	31/8/2011	PV00160936
C000002	16/9/2011	PV00161412
C000002	19/9/2011	PV00161447
C000002	20/9/2011	PV00161459

and this table

Month&Year	Number customers
March-11	1
April-11	1
May-11	1
August-11	1
Sept-11	3

Thank's for your help

[sunny_talwar]

Do you have a MonthYear field screated in the scipt? If you do, then create a straight table like this

Dimension

MonthYear

Expression

Count(DISTINCT Custaccount)

[Anil_Babu_Samineni]

Perhaps this?

Month(created_at) as Month

And create table with

Dimension : Month

Expression : 

Count(TOTAL <Month> Custaccount)

[sunny_talwar]

@Anil_Babu_Samineni  - Why do you need TOTAL <Month> here? I think there is no point of adding TOTAL <Month> when you only have Month as the dimension.

[Anil_Babu_Samineni]

@sunny_talwar 

My intention adding TOTAL qualifier is, if customer added another dimension and they need for month based TOTAL count.

[sunny_talwar]

Oh, so you are assuming if another dimension is added... but what if they don't want to see the total after adding another dimension... I don't think it is right to assume that when another dimension is added, it should still total by Month. But if that is needed, then you are right.

[ecabanas]

Hi all

Sorry, maybe I explained bad....I want this new table in load script, to save it in a qvd and use in another app.

Thank's