Output - Filter and multiple outputs based off field names

Hi all,

Hope you can help - I'm sure there is a sort of way of doing this based off the output settings but everything I am trying is coming up with an error.

I have a workflow which has thousands of rows, essentially what I want to do is run it so it outputs multiple excel files based off the specific field name.

I have attached a dummy file for reference - essentially I have built the workflow to assign a unique code to unique names and i want the output to create a table for each unique code so for example if the code is "11" I would want a file that shows Row 2, 11 and 14 as one table whilst the code 22 would have a seperate file containing rows 3, 12 and 15.

I'm hoping that there's a simpler way of doing this rather than creating multiple output connections?

The plan is to eventually turn this into an analytical app and have the end user filter based off their unique code, but again, not sure if this will be possible.

Any help / guidance / suggestions appreciated, thank you!

EDIT: I added a table and layout tool on the end of my data due to the number of fields - is there a way of applying the same concept from this?

DUMMY FILE.xlsx

Gallery

Output

Help

Accepted answers

AngelosPachis

@Lili7891

In case you want to create a different file for each unique code, what you have to do is create the filepath where you want those files stored into with a formula tool.

I have selected to save it on my Desktop and the sheet name to be Sheet1 for each excel file for example, but you can go on and amend it to work for your case.

You have to make sure that you change the filename with the unique code

and then in the configuration window of that output tool, you have to select to change the entire filepath, based on the field you have created in your formula tool

Let me know if that worked for you.

Regards,

Angelos

example.yxmd

AngelosPachis

@Lili7891 I have included a table tool and a layout tool in the workflow, although I wasn't sure how to configure them.

But you can use a render tool if you still want to create a unique Excel output for each one of the unique codes you have in your dataset.

So even though I have included the reporting tools, I still get an output in an Excel format ( you can even change it to a pdf format, if you like the looks of the tables in Alteryx)

And we can still convert this into an app, with a similar concept as before. Would that work?

example_v2.yxwz

All comments

AngelosPachis

Hi @Lili7891 ,

Have you tried changing the configuration of your output tool to "change the file/table name" based on the field Unique Code?

Screenshot 2021-02-16 172122.jpg

What this will do is create a single output file, but then you will have multiple sheets within that file, as shown below

Hope that helps,

Angelos

AngelosPachis

@Lili7891

In case you want to create a different file for each unique code, what you have to do is create the filepath where you want those files stored into with a formula tool.

I have selected to save it on my Desktop and the sheet name to be Sheet1 for each excel file for example, but you can go on and amend it to work for your case.

You have to make sure that you change the filename with the unique code

and then in the configuration window of that output tool, you have to select to change the entire filepath, based on the field you have created in your formula tool

Let me know if that worked for you.

Regards,

Angelos

example.yxmd

AngelosPachis

And here is a proof of concept of how the app could work

example.yxwz

Lili7891

@AngelosPachis the app concept is brilliant. I also realised I needed to add a table and layout option on the end which means the output option doesn't work here 😞 so very nearly there, so thank you for your help!

dasbintee

Hi,

Thank you for sharing this solution. I followed all these steps and I have created a similar solution before where I created multiple files based off of a field name but somehow now I get an error on the output tool saying "Error opening file name: [Path]".

Would you please be able to help me in troubleshooting?

Thanks,

Bintee

dasbintee

Okay just figured it out - my file names had some characters that an excel file name can not have - fixed that and works just fine now! Thanks!

singhthatcoddes

Hi, I used your solution for my purpose. However, there is a small twist.

For simplicity I have kept only two columns but I need to filter and create outputs for the unique no of labels given in the first column.

Please can you help in modifying the app solution to fit my requirement.

Input File for Alteryx.xlsx

aschuster

What am I doing wrong if I keep receiving the error "You Must Specify a sheet name"? I created a formula with filepath and listed "sheet1" in the formula.

10-31-2023 11-39-22 AM.png 10-31-2023 11-40-51 AM.png

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157