How to write value in next column excel when two column values are matching from different excel

Help
1

Hi I compared two excel work books columns and where column values are matching in need to write the value in beside column of it can any one help me with this. I attached screenshot alsoCapture

2

Buddy @ryava_santhoshi

once after this if condition
use assign activity like buddy in THEN or ELSE part as per your validation
row(col_index) = “the value you want to enter”
where
col_index = dtValue.Columns.IndexOf(“MetricId”)+1

Thats all buddy
Cheers @ryava_santhoshi

1 Like
3

Did that work buddy @ryava_santhoshi

1 Like
4

thank you so much for quick reply @Palaniyappan alaniyappan
here I am attaching my excel workbooks. first I need to compare these excel workbook MetricId columns. where ever both columns are matching I need to enter the Value1 column values from value excelworkbook to master exceldataworkbook. Can you please watch them once and confirm me. I compare them but how to use write cell in value1 columnwhere they both matchingMasterdata.xlsx (11.2 KB)
Value.xlsx (11.1 KB)

1 Like
5

Buddy @ryava_santhoshi
its resolved buddy
here you go, run it buddy, you can see the result in Masterdata.xlsx - sheet2
col.zip (18.9 KB)

Cheers

1 Like
6

Hi @Palaniyappan thank you so much for quick help, but Capture1 when I tried to open this. I am getting this error not able to open this xmal. can you please help me with this.

7

buddy @ryava_santhoshi
see this and kindly let know buddy

Cheer

1 Like
8

@Palaniyappan, I did as in above suggestion but still not working. i am using 2016 version maybe you dev in 2018 version. if possible can you please put snipping shots of this ( I mean screenshots of this).

1 Like
9

got solution thank you so much for quick answer @Palaniyappan

1 Like
10

Thats great, buddy
Cheers
if so kindly make a solution buddy
@ryava_santhoshi

1 Like
11

Rowindex=DataTable.Rows.Index(matchingrow)
in write cell if you want to put in column D which is beside to matching column write at cell value as “D”+Convert.Tostring(Rowindex+2)

1 Like
12

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