Select First X Number of Columns

Hello, I know there is a way to select columns based on the names of those columns, but is there a way to select the first four columns in a table? So regardless of what those columns are named, it would always just pull out the first 4.
I think this is important if your data is constantly adding new columns based on an API connection, and you want to analyze only the latest columns.

Hi Emery!

We do not have native functionality to select the first X number of columns, but I believe this can quickly be accomplished through the following steps:

  1. Flip table so that columns become rows and rows become columns
  2. Limit rows to the first 4 rows in the table
  3. Flip the table back so that columns are back in the original spot

A screenshot of this process is below. You can also paste in this snippet into your flow: parabola:cb:18766b3d-b8ed-4a53-8898-5588c7f7eaae

Try this out and let me know if this works for you.

1 Like

Thank you. I will give that a try.