Count the number of times the order number occurs

[#1]

Hi

I wanted to count the order number for how many time it occurs, below it the screen shot

this will help me to bucket based on orders, Please help

DisPOAmount	PO.numbers	Line.numbers	UniqueCount
105901FKI	10590	1	22
105902FKI	10590	2	22
105903FKI	10590	3	22
105904FKI	10590	4	22
105905FKI	10590	5	22
105906FKI	10590	6	22
105907FKI	10590	7	22
105908FKI	10590	8	22
105909FKI	10590	9	22
1059010FKI	10590	10	22
1059011FKI	10590	11	22
1059012FKI	10590	12	22
1059013FKI	10590	13	22
1059014FKI	10590	14	22
1059015FKI	10590	15	22
1059016FKI	10590	16	22
1059017FKI	10590	17	22
1059018FKI	10590	18	22
1059019FKI	10590	19	22
1059020FKI	10590	20	22
1059021FKI	10590	21	22
1059022FKI	10590	22	22

Regards

AJ

[Anonymous]

Hi,

Find below solution. In expression you can use whatever is required. As of now I just put sum of line no. to get the result

screen shot was your expected output correct.

If it is not let me know your requirement.

[#3]

I need this to happen in the back-end so I can bucket it to different category,I am able to achieve this using expression

[Anonymous]

ok ... then use this code in your script... you can use applymap as well.

A :

LOAD DisPOAmount,

     PO.numbers,

     Line.numbers

FROM

(ooxml, embedded labels, table is Sheet2);

load

  PO.numbers,

  count(PO.numbers)as uniq_count

  Resident A

  group by PO.numbers

[tresesco · Accepted solution]

Check attached smaple qvw.

[#6]

Thank you very much