Formula to identify unmatched column sources

Question

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.

match data sources.yxwz

ArnaldoSandoval · Answer

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

match data sources-B.yxwz

nagakavyasri · Answer

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