# How to remove column based on Index Position?

**URL:** <https://forum.knime.com/t/how-to-remove-column-based-on-index-position/90261>\
**Category:** KNIME Analytics Platform\
**Tags:** excel\
**Created:** [October 22, 2025, 9:25am UTC](https://forum.knime.com/t/how-to-remove-column-based-on-index-position/90261 "2025-10-22T09:25:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![GD3F2UV](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/g/a587f6/32.png) [@GD3F2UV](https://forum.knime.com/u/GD3F2UV)\
**Post date:** [October 22, 2025, 9:25am UTC](https://forum.knime.com/t/how-to-remove-column-based-on-index-position/90261/1 "2025-10-22T09:25:26Z")

</div>

Hi,

I have a situation where I have a excel table as output having 55 columns in total in my KNIME WF. From this table, I want to remove columns which is position 8, 9, 10, 12, 13, 15, 16, 18, 19, 21, 22, 24, 25, 27, 28, 30, 31, 33, 34, 36, 37, 39, 40, 42, 43, 45, 46,48,49,51,52,54,55 and I want output as rest of columns. How can i achieve this to remove column based on position and not column title?

Thank you in advance for your help!

---

<div class="post-metadata">

**Author:** ![alpayzeybek](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alpayzeybek/32/78562_2.png) [@alpayzeybek](https://forum.knime.com/u/alpayzeybek)\
**Post date:** [October 22, 2025, 9:51am UTC](https://forum.knime.com/t/how-to-remove-column-based-on-index-position/90261/2 "2025-10-22T09:51:59Z")

</div>

Hi,

What about transposing them, then using rule based row filter based on row index number (meaning old column index number) and transposing them back again?

My idea –\>

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

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/0/20214a928cd610f25d581f30da48eb616dd54318.png)

Initial table:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/7/e/7e65dddc47f0220baa9d9e2b4a12504f10dad69d.png)

Latest table:

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

Best,

Alpay

---

<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:** [October 22, 2025, 12:35pm UTC](https://forum.knime.com/t/how-to-remove-column-based-on-index-position/90261/3 "2025-10-22T12:35:12Z")

</div>

@alpayzeybek this will work but you will always process the whole dataset? This approach uses the structure of the table and excludes the columns based on the position.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/7/4/7419276d341a77bd756d6005a3fe413cae92911c.png)

> **[Exclude Columns by Index - KNIME Forum (90261) – mlauber71](https://hub.knime.com/mlauber71/spaces/Forum/2025/Exclude%20Columns%20by%20Index%20-%20KNIME%20Forum%20(90261)~zjVC38N5IKWQrcIL/current-state)**
>
> Exclude column by Index (position)

---

<div class="post-metadata">

**Author:** ![alpayzeybek](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alpayzeybek/32/78562_2.png) [@alpayzeybek](https://forum.knime.com/u/alpayzeybek)\
**Post date:** [October 22, 2025, 1:21pm UTC](https://forum.knime.com/t/how-to-remove-column-based-on-index-position/90261/4 "2025-10-22T13:21:32Z")

</div>

You’re absolutely right — my approach processes the whole dataset since it temporarily flips everything.  
I mentioned it mostly as a “node-only” workaround for quick prototyping, especially when scripting or metanodes aren’t an option.

Your method using the table structure is definitely more efficient for larger datasets or production flows.  
Thanks for pointing that out. Below version of my flow seems also much easier to apply.

Thanks,

Alpay Zeybek

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/0/80415fb58a27cc9d6ddf4d340073c1aba139dd9d.png)

---

<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:** [January 20, 2026, 1:22pm UTC](https://forum.knime.com/t/how-to-remove-column-based-on-index-position/90261/5 "2026-01-20T13:22:20Z")

</div>

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