dynamic Date and sheet in one output

[Krish_Penubarthi]

Hi,

I am trying to output a file where I am creating the file name dynamically. I have achieved this using formula tool and Output tool.

I also want to dynamically split the data based on a particular field value which I am not able to achieve.

Eg: C:\Users\Desktop\output run for 10_10_2020.xlsx and I am running this for 5 countries. 

I want to split the data into new sheet whenever country changes.  Any suggestions on how this can be achieved

[atcodedog05]

Happy to help 🙂 @Krish_Penubarthi 

Cheers and Happy Analyzing 😀

[Krish_Penubarthi]

@atcodedog05 @Emil_Kos @Qiu 

It is working now. Thank you all for the quick turnaround.

[Qiu]

@Krish_Penubarthi 
Thank you for the feedback.
Appreciate if you could also mark my solution as accepted 😁

[Qiu]

@Krish_Penubarthi 
@atcodedog05 gives the perfect answer for it.