Validating input file name - Excel

[dpatel53]

Hi, 

I am inputting 10 files into Alteryx. I need to make sure that the each of the files have the same name each month when uploaded. I want to make something where it checks the file name compared to the name i want... something that tells me "Pass/Fail". At the end, i hope to have a small 2 column table where i can have the file names and if the file passed the file name validation. 

Thanks! 

[ChrisTX · Accepted solution]

one option:

A: Use a Text Input tool to store the file names you want

B: Use a Directory tool to read the file names from a folder

Use a Join tool to Join A to B.  Any output in the Left or Right anchor of the Join is a mis-matched record.

Chris