Count the Customers

[rajkumarb]

Hi all

I need to count the number of customers over the time, in Load Script

but i need to create a new field with their number of visit added together

for better explanation i attached the xls with data and expected output

please suggest

[vinieme12]

how is 12347 = 8  , when you only have 5 rows of data for each customer, can you explain in detail?

12347	12/1/2016	8
12347	12/2/2016	8
12347	12/3/2016	8
12347	12/4/2016	8
12347	12/5/2016	8
12347	12/6/2016	8
12347	12/7/2016	8
12347	12/8/2016	8

[surendraj]

Hi,

In your specified .xls file have only 5 records for all three customers.

am i relevent to your expected output?

--surendra

[vinieme12]

Anyways, you can use below

count(TOTAL Date)

[rajkumarb]

Hi

please download the book1 again

i changed it

yes it is relevent

[vinieme12]

try

count(TOTAL Date)

[rajkumarb]

Hi

In Load Script

[vinieme12 · Accepted solution]

Use the Expression in Chart if you want in load

Then

FACT:  

LOAD Customer_ID,

     Date

FROM

(ooxml, embedded labels, table is Data);

left join(FACT)

Load Customer_ID,

     Count(Customer_ID)

Resident FACT

GROUP BY Customer_ID;