Hi all, good day. i have an example 2 data table.
dtTableReport - let say there are 300,000 record on it.
dtTableAvClass - this table is for lookup
i would like to lookup the Classification from dtTableAvClass using ClassId in dtTableReport. how can i do this without using for each activity. this activity takes sometime to do it specially the record in dtTableReport is more than 300k. thank you.
(From row1 In dtTableReport.AsEnumerable
Group Join row2 In dtTableAvClass.AsEnumerable On row1(0).ToString Equals row2(0).ToString Into Group
From grp In Group.DefaultIfEmpty()
Select ra = row1.ItemArray.Take(2).Append(If(grp Is Nothing, Nothing,grp(1))).ToArray
Add this to an assign activity where left side is your output datatable and right is the above linq