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.
Solved! Go to 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,
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!
@Thableaus this is beautiful!