Dynamically delete columns based on todays date

[PrashantJP]

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

Process	Date	MTD Uploads	90 Day Prior Ageing	Ageing	January	February	March	April	May	June	July	August	September	October	November	December	Future NRD
AM EMEA	2022-10-18	0	452	0	1,797	11,410	6,529	2,377	5,982	12,599	11,226	8,117	2,981	5,162	5,828	15,841	22
AM Asia	2022-10-18	0	529	0	133	237	2	0	0	0	194	334	574	529	522	519	0
AM NA	2022-10-18	0	66	0	331	3,008	2,065	543	1,966	3,898	3,224	323	403	1,038	1,227	4,050	333

[DataNath · Accepted solution]

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

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

@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 solution]

Many thanks @grazitti_sapna ! It worked!