Hi! I am no good at LINQ and find it efficient vs multiple-for-each activity, especially on tables with thousands of rows. Hoping you could help me with the following scenario.
DataTable Reference has the following columns: Keyword, Domain, Type
DataTable FileToFilter has the following columns: Mailbody, Sender, Time Stamp, Type, Code
Now, if the string from Column: Mailbody(in dtFileToFilter) contains the string from Column: Keyword(in dtReference) AND if the string from Column: Sender( in FileToFilter) contains string from Column: Domain (in reference) Then the row value from DT Ref columns: Keyword and Type are copied respectively to DT FileToFilter Columns: Code and Type
Not sure if I am asking it correctly but below is the expected output