Dynamic Select?

IJH34

I am looking a solutiont that will select the PRDNO, LOCATION, KEY, and the current month's data (i.e. May) whenever I run my workflow. 

BEFORE:

PRDNO	LOCATION	KEY	19-Apr	19-May	19-Jun	19-Jul
640037000	003	SST	326	326	326	326
640037000	003	NET	252	472	503	502
640037000	003	DEM	207	257	285	243
640037000	003	SOH	49	0	0	0

AFTER: 

PRDNO	LOCATION	KEY	19-May
640037000	003	SST	326
640037000	003	NET	472
640037000	003	DEM	257
640037000	003	SOH	0

I believe dynamic select will accomplish this but I'm not sure how to say give me the fields that contains the current month abrv. 

Thableaus

Hi @IJH34 

I think this works well:

Use Dynamic Select Formula:

IF [FieldNumber] <=3 OR ToDate(DateTimeParse([Name],"%y-%b")) = ToDate(DateTimeTrim(DateTimeToday(), "month")) THEN "True"
ELSE "False" ENDIF

Cheers,