How to update status based on row values in excel

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

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

1 Like

Hi @ppr @Sudharsan_Ka

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

there is no clear pattern, which indicates the status

Please tell me any possible way to fix this problem

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

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

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

@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

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:

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

Best,
Charbel

2 Likes

Cross Link:

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

This should do the work:


Forum_ExcelComparison.xaml (13.9 KB)

Best,
Charbel

Hi @Charbel1

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

Regards,
Raja G

Just updated the previous post with the new workflow.

@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

Check this one:

Forum_ExcelStatus.xaml (8.3 KB)

1 Like

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

Thank you so much @adarsh_kotagiri , i got a solution

1 Like

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