Put value from one datatable to another for a specific condition

I have two files
Sample1.xlsx (8.3 KB) Sample2.xlsx (8.2 KB)
and want to assign the “no” status with those contain value in Sample2.

I tried the Main.xaml (12.9 KB) workflow but the results are not coming correct.

The result should look like

Can anyone please help.

do you want to write in a same excel or another excel?

in sample1 where ever you find “Hi” and “Hello” you want to replace with “No” right?

Can you tell me what condition u wann check ?

yes You are right i want to replace the “no” value to hi hello as in excel 2 in the same excel sheet i.e. sample1

1 Like

ok ill send you the sample

use the for each row,
and use if condition.
row(“status”).ToString.Equals(“Hi") OR row(“status”).ToString.Equals(“Hello”)
then assign acttivity row(“status”)= “no”

1 Like

Replace with other excel.zip (14.0 KB)
let me know if this helps
Cheers @Soniya215

Main.xaml (8.7 KB)

find the attachment of your required result

assign the same excel path in excel application scope

@Soniya215…This solution will get you the desired results. Please try and update.Sample.zip (28.4 KB) SampleOutput

Thanks a lot for the help to all and @Akhilesh_Singh your workflow best suited my flowchart.

Again thanks a lot. :slight_smile:

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