Trim columns in a table

1

Is there a way to trim columns from a table?

I have a table as follows:

|Revenue Type|Jan 2024|Dec 2013|Nov 2023|

and I will keep adding months to the table.

However, I basically only want 12 months of data to show, so in other words to keep the first 13 columns.

I know I can get around this by setting up only the required columns and then using the "Append another table" to pull in the figures to only those columns, but I wondered if there was an easier way to trim columns?

2

You can build a list of necessary columns using the "Table metadata" action and then use the "Select columns by lookup" action to select only the columns in that table.

1 Like