I have a variable type data table that I get from an excel
what I have to do is write that data table in another excel that already brings the number column so I must write the name column according to the number it has in the number column
how can I do that I already know how to write but I don’t know how to see if they are the same and write in the right column
Please correct me if wrong…
You have a excel with numbers and name…
In the new sheet you just have the numbers, you want to populate the name in front of it ?
If I mis-understood it, please clarify
I dont get much the queries but can you give input excel and the output desire excel to easily address the issue. Thanks @Ivan_torres_oliva
So it is in the excel I only have numbers and I want to put the name but according to the number that already has in my variable data table
Use build datatable activity
And data row activity
You mean join the two excel’s table?
Read both excels.
Join Data Tables with the Column Number as their equal column and assign to dt_Out.
(Assumption: Column Number has unique values)
Depends on your needs, decide what Join Type.
Write the dt_Out to your second excel.
I already read the two excel and joined them by column number but I don’t know how to paste them in the second excel according to the number they have
and this is the excel where I must paste the data excel2
EXCEL1.xlsx (8.6 KB) EXCEL2.xlsx (8.6 KB)
I attach my two files in case you need more references and can you help me
the numbers vary in quantity so I can’t just specify the range “B4: C7”
could you also provide a screen shot of your Join Data table Wizard?
and how do you write them to the second excel?
from what i see,
Input Dt 1 should be the excel 2 dt
Input Dt2 should be the excel 1 dt
Join Type is Full or Left ( definitely not Inner if you want to retain the previous data of excel 2)
looking at it in another way you will have to write the name column of Excel 1 in the name column of Excel 2 after the last cell with data from the same column name of Excel 2
Ahhhh now that you mentioned it! Hahaha
We should separate the EXCEL2 NUMBER with data and without data before we play around with it. I think we need use Filter Data Table and Append Range.
I’ll get back to you with a sample xaml if you or someone don’t beat me to it.
Like this perhaps, if implementing it purely with UiPath activities?
Instead of Append Range, I used Merge Data Table, btw.
(I bet Data LINQ skilled people will suggest other ways, though)
Hope it helps!
DatabaseJoinForum178706.xaml (9.5 KB)