Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Filter to exclude specific Excel filename

tviz21
Asteroide

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 RESPUESTAS 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
Cuásar

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
Cuásar

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
Asteroide

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

 

Toni

Etiquetas
Autores con mayor cantidad de soluciones