Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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