# Rule based Rank

**URL:** <https://forum.knime.com/t/rule-based-rank/44426>\
**Category:** KNIME Analytics Platform\
**Created:** [June 21, 2022, 5:07pm UTC](https://forum.knime.com/t/rule-based-rank/44426 "2022-06-21T17:07:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vincentsoy](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/v/ecb155/32.png) [@Vincentsoy](https://forum.knime.com/u/Vincentsoy)\
**Post date:** [June 21, 2022, 5:07pm UTC](https://forum.knime.com/t/rule-based-rank/44426/1 "2022-06-21T17:07:38Z")

</div>

Hi,  
i’m trying to rank the APU but i want to skip the rows where the APU = 0 without removing or changing the order of the rows. I tried the Rule Engine Node but couldn’t make a valid rule.  
Is there a better way to do it ?

 ![Bildschirmfoto 2022-06-21 um 19.03.51](https://forum-cdn.knime.com/uploads/default/original/3X/b/8/b8f04cc651a469e3c273fb78efbfa50a6d25f4b6.jpeg)

---

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [June 21, 2022, 5:32pm UTC](https://forum.knime.com/t/rule-based-rank/44426/2 "2022-06-21T17:32:09Z")

</div>

@Vincentsoy you could try a combination of Rank, Counter, RowID and Rule based row splitter. You can preserve the RowIDs and the oder with the help of the counter node. you might also have different sortings and bring them back together with the Concatenate node.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/5/3550376f51dcdb8c905230faec2e069888e72d71.png)

> **[Split ranks with a rule (forum 44426) – mlauber71](https://hub.knime.com/mlauber71/spaces/Forum/latest/2022/kn_forum_44426_rank_with_rule~FwA-GrWqMCyh3GkQ)**
>
> Split ranks with a rule (forum 44426)

[kn\_forum\_44426\_rank\_with\_rule.knwf](https://forum.knime.com/uploads/short-url/cHwwbQ0C68WIOyV3KJmlNUde7RG.knwf) (45.6 KB)

---

<div class="post-metadata">

**Author:** ![Vincentsoy](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/v/ecb155/32.png) [@Vincentsoy](https://forum.knime.com/u/Vincentsoy)\
**Post date:** [June 21, 2022, 5:34pm UTC](https://forum.knime.com/t/rule-based-rank/44426/3 "2022-06-21T17:34:49Z")

</div>

Thanks again for the fast reply @mlauber71  
I’ll try!

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 28, 2022, 5:35pm UTC](https://forum.knime.com/t/rule-based-rank/44426/4 "2022-06-28T17:35:22Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.