Dynamically delete columns based on todays date

Question

Hi All,

I am looking for a solution which can dynamically keep the required columns and remove other columns. Example, if I run the workflow in october, it should show me columns for october, November and December and the rest of the columns (Jan,Feb, Mar, Apr, May, June, July, Aug and sep should not appear in the output. Could you please help me with the same or point to a tool that can be used for achieving this

ProcessDateMTD Uploads90 Day Prior AgeingAgeingJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberFuture NRDAM EMEA2022-10-18045201,79711,4106,5292,3775,98212,59911,2268,1172,9815,1625,82815,84122AM Asia2022-10-180529013323720001943345745295225190AM NA2022-10-1806603313,0082,0655431,9663,8983,2243234031,0381,2274,050333

DataNath · Accepted Answer

Hey @PrashantJP, how do you get on with something like this? We leverage the Dynamic Select tool and check that each field is either a) not a month or, b) parses the month and checks that it's equal to or larger than the current:

RobertZiegl · Accepted Answer

Hi,

I would recommend to use the transpose tool to turn the colmns to rows, filter with a simple Filter tool and turn the rows back to columns wiht the cross tab tool.

for the filter i would recommend turning the Months to int or a date & compare it with DATETIMETODAY().

grazitti_sapna · Accepted Answer

@PrashantJP , Please use the below workflow to get your desired result. You can extract the month from date time now and then filter your data on the basis of it. Please let me know if it was helpful.

PrashantJP · Accepted Answer

Many thanks @grazitti_sapna ! It worked!