This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I am quite new to Alteryx and am wondering if there are some Alteryxians here willing to share advice and/or ideas.
I am currently trying split records into different tabs by values in excel file as output and am utilizing the feature in Output Tool called "Change File/Table Name". At the same time, I also want to make use of the "Change Entire File Path" to generate dynamic file name. But since Output tool only allows one selection of 'feature', I was wondering if you have any idea/suggestion to circumvent this?
The key lies in the formula tool where we first setup the dynamic sheetname with formula with the aim to split records into different tabs, and then use the Output Tool to change the filepath based on the Filename generated with Formula.
One question though, I tried your method and it works great for the most part, but it returns error when there is actually no data in the [Country] or any field that will be assigned to be sheetname. Is there a way to ignore the error and let the empty excel be created when there is no data?
You can use If statement to rename it like giving the word blank that time it will not create error.
For a successful output there should not be Nulls in filename or sheetname. You need to handle them before generating filename. You can replace to it to blank/sheet1(for sheet) or take value from another column.
My first solution was tailored for your specific requirement. Can i get your feedback on did it fail anywhere or why did not choose to go ahead with it. Would it because of the example taken or the the workflow didn't work as expected.
Your feedback will help me to improve my approach of solution, example taken or anything that will improve the overall experience.