Put value from one datatable to another for a specific condition

Help
1

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
image

Can anyone please help.

2

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

3

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

4

Can you tell me what condition u wann check ?

5

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
6

ok ill send you the sample

7

Hi,
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
8

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

9

Main.xaml (8.7 KB)

find the attachment of your required result

assign the same excel path in excel application scope

10

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

11

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

Again thanks a lot. :slight_smile:

12

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