True or False then read different files

[ccaohaventreebank]

Hi, I am wondering if Alteryx can do something like, if a statement in Filter is true then read a file, if False then read another file.

Thanks!

[gabrielvilella]

Yes, it is. You can have the file name on a table, use a filter and then read it via Dynamic Input.

[ccaohaventreebank]

Thanks! but how to use if then statement as a switch?

[Felipe_Ribeir0 · Accepted solution]

Hi @ccaohaventreebank 

One way of doing this using the batch input macro (for xlsx files, if your file is not xlsx you need to change the file type inside of the macro):

[apathetichell]

I would recommend that you feed in the filename via a batch macro - this is pretty straight forward and worth your time to read up on... Without knowing what type of files you're choose between - take a look at this weekly challenge for ideas:

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-180-Thousand-File-Challenge/td-p/461356

The solutions to this challenge don't just change the name of the file being read in - they change the file type too!

[ccaohaventreebank]

thanks! This is very helpful!