Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Output - Filter and multiple outputs based off field names

Lili7891
7 - Meteor

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?

 

11 REPLIES 11
AngelosPachis
16 - Nebula

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

AngelosPachis_0-1613496131205.png

 

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

 

AngelosPachis_1-1613496182794.png

 

Hope that helps,

 

Angelos

AngelosPachis
16 - Nebula

@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 

AngelosPachis_0-1613496445053.png

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

 

AngelosPachis_1-1613496495467.png

 

Let me know if that worked for you. 

 

Regards,

 

Angelos

 

AngelosPachis
16 - Nebula

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

 

example.gif

Lili7891
7 - Meteor

@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!

AngelosPachis
16 - Nebula

@Lili7891 can you provide a bit of extra information on what we are after now that the table/layout tools have been added?

 

Do you want to output different tables for each one of the unique codes for example after your reporting tools?

AngelosPachis
16 - Nebula

@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. 

 

AngelosPachis_0-1613512210813.png

 

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)

 

AngelosPachis_1-1613512282584.png

 

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

Lili7891
7 - Meteor

Thanks a million, this set me on the right way, needed to adjust some setup due to the data being fed in but got the result I wanted in the end! 🙂

dasbintee
5 - Atom

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
5 - Atom

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! :)

Labels