Comparing 2 columns and i am new to automation please give me the full solution

Help Studio
, , , ,
1

How to compare Column A and Column B and write in Column C in same sheet and in same excel file and not creating new excel file using uipath automation

2
  1. use read range activity to read the values from column A and column B
  2. use if condition to compare values
  3. use write cell activity to write back to the excel

If you want the solution share the input excel and what is comparison needed

3

Hi @Lak_Ui

what is the condition should write in if condition please mam and thanks in advance mam

4

what is that exactly you need

you need check whether column A =Column B and then write the result to column C?

5

wait i will send you the excel file mam

1 Like
6

Compare.xlsx (8.4 KB)
in this input file i want read the column A and Column b and Write in column C using uipath that is Column A + Column B=Column C and write in same sheet

7

@Lak_Ui
mam can you send me the solution ?please

8

i can see that column A is having letters…Do you want to avoid the letters and do addition operation?

9

@Lak_Ui
don’t avoid the letters and not adding for example : B4283 707757.4
the operation should be like this which i have mentioned above the example

10

the example is fine i think so mam can you please send me the solution

11

Main.xaml (6.3 KB)
Please find attached the solution

12

@Lak_Ui
i don’t see any solution there it is same mam

13

please check the attached xaml file

14

image
image1920×1080 193 KB

if i run this it is same please check once mam

15

Hi @sunil.kumar.s.v ,

What is that you need. Please provide more clarity

16

@sunil.kumar.s.v Check this attached workflow,
Uipath_UpdateColumn.zip (9.6 KB)
Hope this may help you :slight_smile:

17

@Manish540
yes! and thank you so much for quick response sir :blush:

18

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