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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels