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: SalespersonStateJanuary FebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberAmy LangCA1011152070156331055Reese DawnTX999999910887788662 Requested output based on today's(7/17/20) month(July) would show all columns prior to July including the Salesperson and State column. SalespersonStateJanuary FebruaryMarchAprilMayJuneAmy LangCA10111520701Reese DawnTX9999999 Thank you, - Stuart

unselect certain columns based on current month

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

Output

Accepted answers

JosephSerpis

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

Dynamic_Select_17072020.yxmd

All comments

JosephSerpis

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

Dynamic_Select_17072020.yxmd

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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335