Find missing value

[Yogita_Gaikwad]

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

[kumar.varun2 (Varun Kumar)]

Hi @Yogita_Gaikwad

You can follow this approach

xaml for reference

FindMissingValue.xaml (8.2 KB)

[Yogita_Gaikwad]

i have two excel then how i can do it

[kumar.varun2 (Varun Kumar)]

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)

[kumar.varun2 (Varun Kumar)]

Hi @Yogita_Gaikwad

Please close the topic if your query is resolved

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Thanks