unselect certain columns based on current month

[Stuart_C]

Hi,

I'd like to unselect or remove certain columns from my data set based on today's month.  The certain columns to unselect or remove would be today's month till the end of the year.

Current data set:

Salesperson	State	January	February	March	April	May	June	July	August	September	October	November	December
Amy Lang	CA	10	11	15	20	70	1	5	6	33	10	5	5
Reese Dawn	TX	99	9	9	9	9	9	10	88	77	88	66	2

Requested output based on today's(7/17/20) month(July) would show all columns prior to July including the Salesperson and State column.

Salesperson	State	January	February	March	April	May	June
Amy Lang	CA	10	11	15	20	70	1
Reese Dawn	TX	99	9	9	9	9	9

Thank you,

- Stuart

[JosephSerpis · Accepted solution]

Hi @Stuart_C I mocked up a workflow that produces your output. Let me know what you think?

[Stuart_C]

This is perfect.  It does exactly what I needed.  I really appreciate your help @JosephSerpis !

I don't need to worry about the Conv Errors when it's trying to DATETIMEPARSE the salesperson and state column right?

[JosephSerpis]

Hi @Stuart_C the last part of the syntax of the formula "DateTimeMonth(DateTimeParse([Name],"%B"))=null()" is checking for fields that aren't Months e.g. Salesperson and State that fail to be converted to a numeric number to represent the month and passes it through the tool so those columns remain with your data. So yes you are correct.