Compare 1 excel col 1 to 2 excel col 1

Hello guys,
please help me.
I am trying to compare 1 excel col-1 to 2 excel col-1.
but it is taking all value from 1 excel col-1
please refer below img and correct me. I tried to use “<>” instead “=” and paste all else part in then but still it is not working.

the red cross value in output should not come…

Hi @Assetsoft

Have a try of equals instead of = like Yardi(“Pro_Id”).toString.equals(Micasa(row(“Pro_id”).ToString

Thanks
Ashwin S

@Assetsoft
AddHeader

Hi @AshwinS2
I tried but not working showing conversion error string to Boolean.
if i am using write line output from then block its equal value correctly but i want to select not equal t values and proceed further.

Hi @Walker
Add headers Already define…

Hi @Assetsoft

Share the screenshot of if condtion or error

Thanks
Ashwin S

@AshwinS2
pls check… there is two each row i am using

Hi @Assetsoft

Try this Yardi(“Pro_Id”).ToString.Contains(Micasa(“Pro_Id”)).ToString

Check this

Thanks
Ashwin S

Hi @Assetsoft
Main.xaml (9。5 キロバイト)
I can compare

excel

aaa bbb ccc
a1 b1 c1
a2 b1 c1
a3 b1 c1

Hello @Walker
same thing I have done in my

can you please share with excel file ?
what i want is that what ever not equal from excel-1 in excel-2 create values new excel-3 with that values from excel-1

good morning @AshwinS2

I tried the same check error

is it possible to you to create workflow for me please ?

1 Like

You were almost done
Remove the last .ToString in the if condition
As the if condition can take only Boolean value abs input and here as we are trying to give input as a string it’s showing us the error

And make sure that we have used a BREAK activity in the THEN part of If condition at last to avoid looping again and again even after the match is found
This will improve the performance as well

Cheers @Assetsoft

1 Like

Hi @Palaniyappan.

I tried as you said.

please correct me if i did wrong.

can you please build workflow for me. i have to finish this today.

that will be helpful.

Final solution is here…

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.