How to write value in the cell, which the 3 columns value are same then write in that row in other column

[saritha_panguluri]

I have as scenario, I have a excel, 4 columns
–and 3 column input is coming from queue
—and 4 th column from one tcode

so if three column data same with queue data then write the value coming from tcode in that row in 4 coumn
how to write if 3 columns match
@Gangadhar_Athili @THIRU_NANI @devika.jaykrishna @ushu

[ninadv99 (ninad)]

@saritha_panguluri ,
Scenario 1.

1. First create blank datatable, get the values from queue in variables , check for matching (you can use if also).
   2.If matching then add the values from variables and tcode in respective columns.
   3.write datatable to excel.

Scenario 2.
1.If you are comparing excel values from data in queue , then read range for that 3 columns and for each row , compare with queue variables
2. if matching then using write cell, write tcode value to excel column.
for exact row take current row count and table rows count.

[RK_0 (RK)]

Hi.
I have attached an xaml and excel file for reference this is not the best method

Try it and let me know
input.xlsx (11.9 KB)
Main.xaml (11.7 KB)

[saritha_panguluri]

SEcond scenario only thank you @ninadv99