How to compare 2 columns of one excel file with 1 column of another excel

Help Activities
, ,
1

Hi All,

I am working on a scenario where I have to compare 2 columns of one excel with 1 column of another excel. I am writing this expression `

Row.Item(“Firstname”).ToString and Row.Item(“LASTNAME”).ToString = CurrentRow.Item(“name”).ToString`

but I am getting error

Disallows implicit conversion from string to boolean

Kindly help in this regard.

Thank u

2

Hi Enthusiastic,

Row.Item(“Firstname”).ToString and + Row.Item(“LASTNAME”).ToString = CurrentRow.Item(“name”).ToString

Instead of and write + sign between them

Also if the full name is having space between them then write +" "+ instead of + sign like this
Row.Item(“Firstname”).ToString +" "+ Row.Item(“LASTNAME”).ToString = CurrentRow.Item(“name”).ToString

Regards,
Firoz