Dynamic Year in Summarize

[STAR1BANU]

Dear Experts,

Requirement - How to Automate my workflow touchless even once in a year too.

I have attached the sample workflow and sample data for reference, 

Yearly once the data has been changed from 2021 to 2022 rest of all the details are the same only next year and month and the amount will be changed in that summarizing tool I am getting error year Jan 2021 to Dec 2021 not found since the data is 2022.

[pedrodrfaria]

Hi @STAR1BANU 

I changed the dataset to be 2022 and ran the workflow with no errors. Can you let us know where the error is happening so we can try to replicate it? Since you are doing a Union, it should not matter the data changing, it would only matter if the column header had changed.

[STAR1BANU]

Sorry, Actually is not summarized tool is transpose tool  attached revised details for your reference, 

Please advise further

[RolandSchubert]

Hi @STAR1BANU ,

I think you could load the header row as as data row, remove the year from the header, re-union header and data and use a Dynamic Rename tool to make the modified first data row your header. Now you always have the same headers, there is no need for change. You can also extract the year from the header row (loaded as data) and add it to the row labels at the end.

Let me know if it works for you.

Best,

Roland