Better way to do Multi File Formulas

[AsmiDesai]

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 

[TheOC]

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

[AsmiDesai]

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.