Alteryx Designer Desktop Discussions

peyton-louden · ‎04-12-2022

Hi all,

I have some data that needs to be filter dynamically as they were will be multiple files in the future. I've attached some sample data for reference but essentially the data comes in one file and needs to separated into separate tabs of a Excel worksheet based on a field in the data.

Above is how the data will look raw.

And this is how the "Car" tab would look.

The sample data has 4 tabs that be separated out but in the future, I would only like create 3 of the four tabs or maybe just 2 of them. I would love a way to select the tabs I want to create instead of creating them all.

Any help would be appreciated!

JagdeeshN · ‎04-12-2022

@peyton-louden

Have you tried using the functionality within the output tool to create these table?

Also for you to select which tabs you want to create, you can do one of these two things:-

1. Use a filter tool within the workflow to only contain the tabs that you want.

2. You can create an interface using the listbox tool and make this select dynamic.

Hope this helps.

Best,

Jagdeesh

peyton-louden · ‎04-12-2022

@JagdeeshN

I've used that feature before and was planning to utilize it in the flow. The dataset I've showed is only a sample of what it will actually be. The true dataset will have close to 40 different possible tabs, but each tab has different field names since the tabs don't contain the same data. The better question would be how to filter dynamically while also having the correct field name without having to manually change them every time someone wanted to select different tabs?

JagdeeshN · ‎04-12-2022

Hi @peyton-louden ,

Are these 40 possible different tabs constant or are they also changing (new ones come in)?

If the number of categories and their respective column names are constant, you can make use of the Dynamic Rename tool by filtering out using the same user selection as tabs.

peyton-louden · ‎04-12-2022

The 40 tabs would be the same, the user would just select different ones depending on which ones they needed. I've never used dynamic rename tool before so I'll have to research it a bit.