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 · Accepted solution]

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,

[kelsey_kincaid]

If you use formulas to calculate the current month, then transpose you can filter based off of your calculated date. Then you can cross-tab the data to reformat it back to the way you want to see it. Example attached.

@Thableaus Your solution definitely works better! I'll have to take a closer look at the dynamic select tool next time!

[IJH34]

@Thableaus this is beautiful!