Hi Team,
Request you to urgently help me on below topic.
I have an input file with 2 column names Payment 2022 and Accruals 01-01-2022.
I am using summarize tool to perform some processing in the workflow.
If the year or date in the column names changes as the year changes for example next year the column names would be Payment 2023 and Accruals 01-01-2023,then summarize tool is giving an error of the column isnt found as it is configured for sum of values in the columns Payment 2022 and Accruals 01-01-2022.
Can you suggest with some workflow that can dynamically take the changes in year and date part of column names without using calendar interface?
Thanks
