Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check attached smaple qvw.
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.
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
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
Check attached smaple qvw.
Thank you very much