Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Compare Like Files by Name

Link86
Asteroide

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 RESPUESTAS 3
OllieClarke
16 - Nebula
16 - Nebula

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
Asteroide

@OllieClarke , Awesome, this helps. Thank you.

HomesickSurfer
Cuásar

Hi @Link86 

 

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

 

Capture.PNG

Etiquetas
Autores con mayor cantidad de soluciones