Formula to identify unmatched column sources

[wonka1234]

Hi,

I am trying to identify from which field the unmatched source is coming from.

I am comparing the sum columns and it tells me which match and which dont .

However for the unmatched, can I identify where it is missing?

please see attached workflow.

[nagakavyasri]

It is comparing Datasource1_field1 with Datesource2_field2, as Datesource2_field2 is empty for few records, the result is showing as 'Unmatched'

[ArnaldoSandoval]

Hi @wonka1234 

Try modifying your formula to:

if Name = Process
then 'Match'
elseIf IsNull(Name) Then 'Unmatched, missing in datasource 1'
else 'Unmatched, missing in datasource 2'
endif

It worked for me 👍

HTH

Arnaldo