Hi,
I have an Alteryx workflow which includes a data set with different countries. Is there a way I can create an output which is an excel document of each different country please?
Thank you,
Hannah
Hi
When you output the data to an excel file, there's an option at the bottom of the configuration pane as below:
This set up would write the results for each Country into a new tab within the same file.
If you want to write them out to individual files, before the output tool and add a formula tool with a field called filename, as below. N.B. Make sure you use the three pipe delimiters and a sheet name (e.g. |||Output) otherwise it will produce an error telling you that you are missing a sheet name.
Then configure the output as follows:
That will get you a new Excel workbook produced for each country.
Hi @HannahSwain,
You could use the bottom section of the output tool for this, the checkbox for "take file/table name from field" will allow you to output multiple files (excel included), one for each variation of the field you select. In your case country.Firstly, choose your output location as you normally would in the output tool (perhaps use a .csv file)
Secondly use the checkbox at the bottom, "Take File/Table Name From Field" and select "Prepend Prefix to File/Table Name" in the dropdown and use your country field as the "Field Containing File Name or Part of File Name".
For my sample data set (which included three countries) I get three .csv files written out, one for France, Spain and UK separately.
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan
Thanks @cgoodman3 this is helpful - I am getting a message to say "You must specfy a sheet name" but I thought I had?
Thanks,
