Find missing value

Transaction_Reference
OPERAMGR
OPERAMKTSEG
OPERATB
OPERA AR AGING

i have 4 above values compare this with below values row by row if any value missing in below values then send mail value is missing

Transaction_Reference
OPERATB
OPERAMKTSEG
OPERAMGR
OPERAMKTSEG
OPERA AR AGINGA

Hi @Yogita_Gaikwad

You can follow this approach

xaml for reference

FindMissingValue.xaml (8.2 KB)

i have two excel then how i can do it

Hi @Yogita_Gaikwad

You can create an array of string values from the first excel after reading it. Please refer the attached xaml which contains the necessary modifications.

FindMissingValue.xaml (11.9 KB)

image

Hi @Yogita_Gaikwad

Please close the topic if your query is resolved

Thanks