Optimize workflow

[SouravKayal]

Hi Team,

I have a huge data set and workflow is taking a long time to process. Does the number of summarise tool affect the run time and formulas as well.

Also I wanted a workaround for a process I am doing already. I have data in columns of Years and Month $. Now I use a filter for year and then rename the month column to add the year to create separate month data for years. 

For Ex Year 2021, 2021 Jan $, 2021 Feb$ etc..

FOr 2022 2022 Jan $, 2022 Feb$... Hence... 

This is taking some time to process. Is there a faster way to do it like a multi field formula or similar?

[Qiu]

@SouravKayal 

You mean like this?

[SouravKayal]

I could not understand the last bit of regex replace and why we added a Z to concatenate