how to get even number columns in excel file?

[kimv4]

Hi everyone.

I’m Mos.

In the excel file, Is there a way to get even column data only?

It’s hard to use Column Filter.

Please help me.

Have a good day.

[kamtaot]

Hi @kimv4 ,

Welcome! It is an interesting question. Can you share a use case for this requirement? Also, my understanding from the question is that you have an excel file and you want to read all even columns (like column 2, 4, 6…etc.) Can you confirm if my understanding is correct?

[kimv4]

Hi @kamtaot
Yeah, That’s right. Also, I can share that.

[tqAkshay95]

Hello @kimv4 ,

You can achieve the desired outcome by using a combination of table transpose, mathematical formulas, and row filter nodes.

Please review the attached images of the workflow and configuration nodes for a detailed walkthrough.

Input:

Workflow:

Configuration

Output:

[kimv4]

Hi @tqAkshay95
I solved the problem with your help.
Thank you
But, I have some questions.

1. Why use the Transpose Node?
2. What is the role of the Math Formula Node?

Really really Thank you!!!

[tqAkshay95]

Hello @kimv4,

If you are satisfied with my response, please consider marking it as a solution.

Additionally, for more information on the table transpose node and math formula node, you can refer to the following links:

Table Transposer

Math Formula

[kimv4]

Ok @tqAkshay95
I checked your answer.
Thank you my teacher!