Formula

[Mayra2291]

Hi,

Is there a way to create this formula in Alteryx?

- Provider has to companies
- Order numbers in both companies can be the same, equal to a combo.

IF {FIXED [Order Number]:COUNTD(Provider)}>1 THEN 'Yes' else 'No' end

Thanks 

[geraldo · Accepted solution]

@Mayra2291 

An example workflow.
Analyze if this is basically what you are thinking

[Mayra2291]

Thank you!