Use of variables (column selection)

Hello - I am in finance and run reports on a monthly basis. I’ve pivoted my data on the dates so that each month represents a column (e.g., 202405, 202406) with the corresponding revenue.

I want to make it so that when running the knime workflow each month, the person running it only has to type in one area (I believe this is the purpose of flow variables) the month they are interested in running analysis on, then in all of the corresponding “Column Splitter” sections, it uses that flow variable to only select that column while removing the others.

I’ve watched a few videos on FLow Variables, and have even read multiple posts and I am still struggling to understand how to do what I am looking for.

Could anyone be so kind in helping me with step by step on what tools to use to a) create the variable, and b) use that variable in the column splitter to achieve what I am looking to do.

Thank you very much in advance for your help and patience with my ‘novice-ness’ :slight_smile: