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

[Emil_Kos]

Hi @Krish_Penubarthi,

I had this issue in the past as well.

Please use this link to find an answer to your problem 🙂

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-output-to-different-sheet-...

Please mark as solved if this was helpful for you!

[Krish_Penubarthi]

Hi @Emil_Kos ,

Thank you for the idea, but I believe my requirement is different.

My output sheet contains 2 dynamic parts 

1) File name which would be - Output run for 10_10_2020.xlsx

2) sheet name which would be split based on value from a field (country field).

Sheet1 - INDIA

Sheet2 - USA etc.

[Emil_Kos]

Hi @Krish_Penubarthi,

Please check if this workflow helps you.

I am assuming that region(a sheet name) would be based on the column in your data. If you need help with that I can mock up something as well. 

[Qiu]

@Krish_Penubarthi 
Just to add to other excellent solutions.
Configuration of Output tool may be what you looking for here.

[Krish_Penubarthi]

Hi @Qiu ,

I am not able to download your file. But I was able to look into the image file you attached.

What if the date has to be dynamically changing, will this work. If I run tomorrow the file name should have 11_10_2020

[Krish_Penubarthi]

Hi @Emil_Kos 

Please look at the attached workflow. I am trying to get an output similar to that. Let me know if that can be done.

[atcodedog05]

Hi @Krish_Penubarthi 

Just a clarification 11_10_2020 is todays date right ?

[Emil_Kos · Accepted solution]

Hi @Krish_Penubarthi,

In the attachment you shared you got a working solution.

The only thing that you need to change is this path:

"\\lcwfsv5\users\e669756\Desktop\Text_"+[Run Date]+".xlsx|||"+[country]

If you will replace the bold text with the output path you desire it will work perfectly for you.

[atcodedog05 · Accepted solution]

Hi @Krish_Penubarthi 

Here is the workflow for the task.

Output:

Sheets:

Date: in formula tool currently i am considering current date you set to required date.

And this file name will output the file in the same folder where workflow is there

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍