Union multiple Filters

[GioTramonto]

Hello,

This seems crazy but I can't seem to union multiple filters?

[Bren_Spill2]

@GioTramonto - can you elaborate on your question a bit? And provide some sample data?

[cmcclellan]

Are you using Designer Cloud or Designer Desktop ?  The screenshot seems to be Desktop but you've tagged it as Cloud.

In Desktop you should be able to use one filter tool, create a custom filter and chain the filters with AND 

[GioTramonto]

Yeah it's Desktop, apologies. Because the data is propriety I can't share it. But all I want do is now that I have my individual spreadsheets that are cleaned, I want to union them all into one sheet (stack them on top of each other.) but, it seems I can only connect 1 filter to the union, not many filters to the union.

Note: each Excel sheet has the same layout/schema. 

Best,

-Gio

[Yoshiro_Fujimori]

Hi @GioTramonto 

You can read multiple sheets as explained in this interactive lesson;

https://community.alteryx.com/t5/Interactive-Lessons/Connecting-to-Multiple-Sheets-at-Once/ta-p/8287...

Once you read from multiple sheets to one table, you can apply filter to the output anchor of Dynamic Input tool.

Good luck.

[Bren_Spill2]

Not sure if @Yoshiro_Fujimori's link covers wildcards - if not then this would be helpful too: Solved: Re: Using wildcard in Data input - Alteryx Community

[GioTramonto]

Yeah I tried using wild cards but 4 out of the 21 files I was loading (again all same template) said the schema was different. So then I just ended up uploading them individually

[Bren_Spill2]

@GioTramonto - then your best bet is a batch macro: Solved: Re: Running Batch Macro on Multiple files from a f... - Alteryx Community

Any issues getting this to work let us know

[Bren_Spill2]

@GioTramonto - this should be helpful for you too: The Ultimate Input Data Flowchart (alteryx.com)

[GioTramonto]

Thanks Bren, yes I have seen the diagram before, which is helpful, but I still do not understand why 17 of the excel sheets loaded but the other 4 did not when they have the same schema. One thing I did figure out is 2 of them were not loading because they have a special character in them, once that one character was deleted, the file loaded just fine. But the other 2 I still don't know. Can you please explain why a batch macro would help with solving this? Thank you in advance.