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
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
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.