ColumnA ColumnB column C
Ashu 20
Charan 30
Kimble 40
I have read both the datatable using read range now in dt1 and dt2.
Now I need to check if row item of dt1 means dt1.row(0) present in dt2 column A or not.
if it present present then I have to copy the value of ColumnB from dt 1 to dt2 for that row.
If dt2.row(0) is not present in column A of dt2 then I have to add that datarow means column A and Column B of dt1 to dt2.
The most simple solution to this problem would be to use two for each row activities, one inside another.
The first one would iterate over d1 table. At the beginning of it set a flag (boolean variable) nameFound to FALSE. Then you can place second For Each Row activity.
Inside it compare if values from both rows are the same. If they are, assign values from d1 to d2 and set nameFound flag to TRUE. Then you can break the loop using break acitivity, if records are unique and you don’t need to check the rest of them. If records are not unique you can iterate over rest of the records.
After you will step out of internal loop set an IF block checking the nameFound flag. If name was not found, then you can add it to the second datatable there.
Of course this is not the cleanest solution, “it’s a simple spell, but quite unbreakable”. I encourage you to try doing that with LINQ, as you would probably be able to do this in a single line of code.
@Mariusz
first stop activitiy would be Join Datatatable configured as FUL Join type.
It is suggested to start ant to explore this if this will do the job.
For more custom requirement then a LINQ statement can be written.
@Karan28
Sure we will help you. Just support us on this with detail input sample data including column structure and clear defined expected output.
Thanks
@Karan28
the Join activity did a good job for doing the full Join
Linq was helpfully for bring it into the target structure:
(From dj In dtJoin.AsEnumerable
Let c1 = If(String.IsNullOrWhiteSpace(dj("Column1").toString), dj("Column1_1"),dj("Column1"))
Order By c1
Let ra= New Object(){c1,dj("Column2"), dj("Column2_1")}
Select dtResult.Rows.Add(ra)).CopyToDataTable
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu