Columns having same data match and fetch in excel

Learning Initatives Automation Starter
, ,
1

Hi all,

Column A has some data and column B has some data. If both are matching means matching data has to be written into Column C.
How to do this. Please help.

Thanks,
Lakshmi

2

image
How to do this.

Thanks,
Lakshmi

3

Hey!

Try this:

  1. Read range-Dtout
  2. Take one assign activity and create one integer variable as counter and initialize with 1
Assign Counter = 1
  1. For each row pass Dtout
  2. Take one if condition pass the expression like this
CurrentRow(0).ToString.Trim.Equals(CurrentRow(1).ToString.Trim)

In then block take one Write cell activity pass the range like this

Range: "C2:C"+(Counter+1).ToString

Next to this take one more assign and increment the counter

Counter = Counter+1

Regards,
NaNi

4

Hi @THIRU_NANI ,
image
What needs to be pass here.

Regards,
Lakshmi

6

Hey!

We can use 1st row or 2nd row… Because the data is same

CurrentRow(0).ToString.Trim

Regards.
NaNi

2 Likes
7

Hi @lakshmi.mp , I hope you are doing well.

Firstly, read your excel data in a datatable using read range.
Secondly, from that datatable check whether column a values matches column b and also keep on storing the cell number using a flag.
Thirdly, if column a value matches column b value do a write cell activity by passing the excel file path and cell number and lastly the value of either column a or column b.

I hope this will help you I am also attaching the workflow for your reference.
Main.xaml (9.7 KB)
Please provide your excel file path in the above workflow, you will get the desired output.

Thank You,
Shubham Dutta

1 Like
8

columnmatch.xaml (7.1 KB)

read excel give as a input outside loop use write range one time

1 Like
9

@THIRU_NANI @Veera_Raj @Shubham_Dutta ,
Thank you all for helping and providing solution.

Thanks & Regards,
Lakshmi

1 Like
10

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