First of all i have a datatable(DT1) that taken by data scrapping.It has 10 row.
Also i have a excel sheet that including 5 person(DT2).
I want to write names of person one by one for each row of DT1.
But robot write all 5 person for each row of DT1.
it mean its written 50 times!!
if my issue is not clear i can try to explain better.Please let me know.
is anyone can help me?
Thank you
Thank your for your interest mate.
But honestly i couldnt understand what i should.
Can you design an example project for me?
I am so new in uipath.Sorry
Thank you for your time.
But rows count of datatables are not equal each other.
DT1 has 10 row and DT2 has 5 row.
I need to write each row of DT2 at each row of DT1.
as like;
DT1 1st row=DT2 1st row
DT1 2nd row=DT2 2nd row
DT1 3rd row=DT2 3rd row
DT1 4th row=DT2 4th row
DT1 5th row=DT2 5th row
DT1 6th row=DT2 1st row
DT1 7th row=DT2 2nd row
…
Assign
ReloopCount=0
Then use for each for DT1
If- ReloopCount= DT2.Rows.Count
Then
Assign
ReloopCount=0
Else- nothing
Assign
Row(Column No or Name )=DT2.Row(ReloopCount)(ColumnNo that you know)
Assign
ReloopCount=ReloopCount+1
dt2Name is a string that contains the result of the Lookup DT2 activity. I defaulted 2 to rowNum because I have included a title/header in row 1 of the Excel file I’m writing to. The Lookup DT2 contains the following configuration:
When I tried to run the bot, the Excel file looked like this afterwards:
For my test data, my DT1 contains the following names: Name 1, Name 2, Name 3, Name 4, Name 5, Name 1. My DT2 contains the following names: Name 1, Name 2, Name 4. Screenshots below:
My friend this is amazing.Thank you for your effort.its work. but its just matching.
Let me explain my situtation again;
I have a datatable that taking from website.So row counts will be unknown.
in the other hand i have fixed datatable taking from my excel folder which including 5 name.
Lets say first datatable that taking from website has 6 row.And my other datatable has 5 row which including names.
I want to write names like this,
DT1 rows - DT2 Names
row1 - Name1
row2 - Name2
row3 - Name3
row4 - Name4
row5 - Name5
row6 - Name 1
if there is 7th row in DT1 - Name 2
if there is 8th row in DT1 - Name 3
…
I mean there will not be same values in both datatable.
But thank you so much for your effort.That will be used by me in the future projects.
Thank you for your time my friend.
I tried the flow but something gone wrong about “write range”
Probably i am done something wrong about variable.
I will keep try and let you know about results.