How to count instances on load

[#1]

Hi There

I am loading several seperate datasets which all look something like this;

CUSTOMER_id	INFO
0100	A
0200	B
0300	C
0200	A
0100	B

I am concatenating the datasets on load and once that is done I want the load script to assign a count to each CUSTOMER_id.

So for the example above I would like to see this;

CUSTOMER_id	INFO	Customer_Count
0100	A	2
0200	B	2
0300	C	1
0200	A	2
0100	B	2

How can I set and store the count?

Thanks

JW

[maxgro · Accepted solution]

a:

LOAD CUSTOMER_id,

     INFO

FROM

[https://community.qlik.com/thread/165076]

(html, codepage is 1252, embedded labels, table is @1);

left join (a)

LOAD CUSTOMER_id, count(CUSTOMER_id) as Customer_Count Resident a group by CUSTOMER_id;

[sunny_talwar]

Try this script:

Table:

LOAD CUSTOMER_id,

     INFO

FROM

[https://community.qlik.com/thread/165076]

(html, codepage is 1252, embedded labels, table is @1);

Join (Table)

LOAD CUSTOMER_id,

  Count(CUSTOMER_id) AS Customer_Count

Resident Table

Group By CUSTOMER_id;

[maxgro]

mayba also in a chart

2 dimension        CUSTOMER_id INFO

expression          count(TOTAL <CUSTOMER_id> CUSTOMER_id)

[#5]

Hi Massimo

Wow, that was quick!

Fantastic, this worked perfectly.  Thank you so much.

JW

[#6]

Sunindia

Fab, thank you.

JW