Alteryx Designer Desktop Discussions

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

Filter to exclude specific Excel filename

tviz21
8 - Asteroid

Is there a way to, when using in my Input Tool, *.xlsx to pull all Excel files from a specific directory, to exclude one file by name?

 

Thanks,

 

Toni

6 REPLIES 6
michael_treadwell
ACE Emeritus
ACE Emeritus

Use the Directory Tool to find all file names in a directory, use the Filter Tool to exclude the unwanted file name, and then use Dynamic Input tool to read all of the remaining files.

s_pichaipillai
12 - Quasar

you can achive this by using,

Directory tool to find *.xlsx files then add filter tool to exclude file name then add Dynamic Input tool to load all other files

s_pichaipillai
12 - Quasar

i and michael_treadwell posted same :)

@michael_treadwell thanks

michael_treadwell
ACE Emeritus
ACE Emeritus

Yeah there seems to be a bit of delay between a reply and when others can see it.

 

I honestly figured you or Dunkerley would have posted before I could finish typing.

jdunkerley79
ACE Emeritus
ACE Emeritus

Was dinner time :). Look forward to first three way tie! 

tviz21
8 - Asteroid

Thanks everyone, appreciate the help, got it to work!

 

Toni

Labels