dynamic Date and sheet in one output

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

Accepted answers

Emil_Kos

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

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 😀👍

Dynamic.zip

All comments

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-names-based-on-a-field/m-p/538742/highlight/true#M115557

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.

Qiu

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

10-14Krish_Penubarthi.yxzp

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703