Alteryx Designer Desktop Discussions

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

Compare Like Files by Name

Link86
8 - Asteroid

Hi,

I am working on a workflow that will tell me about any changes between like files. The files have the same name but come from different directories. I am bringing all files including subdirectories with the directory tool. What I want to do is make sure that files of the same name are always compared. IE: Compare file Invoice from Directory A to Invoice in Directory B. I want to be sure that Invoice from A is not compared to Budget in B. Is there a way to do this?

 

Thank you in advance for your help.

3 REPLIES 3
OllieClarke
15 - Aurora
15 - Aurora

Hey @Link86 

 

One of the fields the Directory input gives you is [FileName]. You can use this as a join clause to only connect the same files

OllieClarke_0-1628533806090.png

Then you can apply your logic.

 

If you only want 1 directory tool, then you can take the following approach:

OllieClarke_1-1628533895299.png

 

Does that help?

 

Ollie

Link86
8 - Asteroid

@OllieClarke , Awesome, this helps. Thank you.

HomesickSurfer
12 - Quasar

Hi @Link86 

 

To ensure ONLY a specific file (w or w/o prefix/suffix), config the File Specification in the Directory Tool.

 

Capture.PNG

Labels