We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Better way to do Multi File Formulas

AsmiDesai
9 - Comet

I have a requirement like below:

 

If File1.id = File2.id

then File2.score=File1.score+1

 

I was able to do this by using a join tool temporarily, but was looking for better way to do this.

Please share if there are any other workarounds 

2 REPLIES 2
TheOC
16 - Nebula
16 - Nebula

hey @AsmiDesai 

My initial reaction would be to join them, and then compare values.

Is there a reason this method isn't suitable?

Cheers,
TheOC

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
AsmiDesai
9 - Comet

Hello @TheOC  ,

 

I have requirement where I might have to do these multi file formula multiple times.

That's why I was looking around if there is any simpler/light weight way rather than using join tool.

Labels
Top Solution Authors