I have a variable type data table that I get from an excel
number name
1 angel
2 ruben
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
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.
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!