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
Solved! Go to Solution.
I had this issue in the past as well.
Please use this link to find an answer to your problem 🙂
Please mark as solved if this was helpful for you!
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.
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.
@Krish_Penubarthi
Just to add to other excellent solutions.
Configuration of Output tool may be what you looking for here.
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
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.
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.
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 😀👍