How to update status based on row values in excel

Help Studio
, , , , , , ,
1

Hi Team,

I want update status based on “Yes” and "No in excel row values , please anyone help me from out this.

I have attached image for yours ref

Condition_Excel

Regards,
Raja G

2

Hi @Raja.G

You can try looping through all the row items in the column and give your condition in if activity

Can you elaborate your condition?

Regards
Sudharsan

1 Like
3

can you elaborate more on the rules / requirements when col A,B,C,D,F will trigger a particular status?

1 Like
4

Hi @ppr @Sudharsan_Ka

its based on particular row values like “Yes” and “No” in each column, i need to update status

5

there is no clear pattern, which indicates the status

6

Please tell me any possible way to fix this problem

7

once you have specified which col / cols combination will get computed to a particular status we can help to implement it.

you was asked for this already

8

Hi @ppr @Sudharsan_Ka

I want find particular column values(column C to H) to one excel to another excel

Excel2

Excel1

Regards,
Raja G

9

As I understood, you want to compare the two excel files and update the Status in the second one based on that, right?

10

@Charbel1

I want particular columns values in excel1, if same columns present in excel2 i want to put status in excel 1

whatever present in column values(C to H) in excel1 same column value in another excel2 present, i need update status “matched” otherwise put “Not matched”

Matching 5 column values one excel to another excel

Regards,
Raja G

11

Okay, first make sure to add Status column using Add Data Column:
image

Then, you can use this for each to update the Status column:

image
image805×551 15.9 KB

Let me know if this is the logic that you are looking for.

Best,
Charbel

2 Likes
12

Cross Link:

13

Hi @ppr @Charbel1

Thanks for solution , i have one small changes need that task.

Sorry to raise again in same task

In Excel2 with status present, Excel1 without status , matching and not matching status not require ,what i need once matching column present in excel2 to excel1 ,i have to pass same status of excel2 to excel1.

Matching column i have different status so only i raised again

Suppose not matched column present, directly i need to put status “No Result” in excel1

Excel1

Excel2

Regards,
Raja G

14

This should do the work:

image
image636×787 21 KB

Forum_ExcelComparison.xaml (13.9 KB)

Best,
Charbel

15

Hi @Charbel1

You sent old task xmal file, please can you send updated xmal

Regards,
Raja G

16

Just updated the previous post with the new workflow.

17

@Charbel1 ,

I checked , that is old one only, please check and send me again

That is not updated only, please check

In image conditions also some part hided in last post

Regards,
Raja G

18

Check this one:

Forum_ExcelStatus.xaml (8.3 KB)

1 Like
19

Hii
Hey chek this file below. Here i have created process for this problem , please let me know if you face any problem with this while executing.

Main.xaml (11.3 KB)
FILE_1.xlsx (8.6 KB)
File_2.xlsx (8.0 KB)

1 Like
20

Thank you so much @adarsh_kotagiri , i got a solution

1 Like