Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys need some help please.
I have list of SuperKey's that have more than one Route-ID. Basically I only need to see the line with highest count which in this case is line 1. How can I achieve this?
SuperKey | ROUTE_ID | RouteID Count |
USAA2000045621OS030C2610 | WHG03 | 528 |
USAA2000045621OS030C2610 | WHG02 | 192 |
Regards,
Raj
Try these two expressions:
=Max([RouteID Count])
=FirstSortedValue(ROUTE_ID, -[RouteID Count])
Try these two expressions:
=Max([RouteID Count])
=FirstSortedValue(ROUTE_ID, -[RouteID Count])
May be do something like this:
Table:
LOAD SuperKey,
ROUTE_ID
[RouteID COUNT]
FROM Source;
Right Join(Table)
LOAD SuperKey,
Max([RouteID COUNT]) as [RouteID COUNT]
Resident Table
Group By SuperKey;
Hi both thank you for the quick reply highly appreciate it. I am still working on it as there are some changes in the requirement. I will soon check and let u know if i am successful
Thanks a lot
Thanks guys both solutions are great and first one fits my current requirement.
Sunny T solution may not be used for now but will definitely be useful in future.
Glad we were able to help