Compare Datatable values with array using linq

Help Activities
, , ,
1

Hi,I have datatable ,and and array of string and i want to compare datatable value with array values,after compare need those data in a datatable using linq query?

Below is an example:

arrStr={“not required”,“no template required”}

dt_table

image
image221×166 2.28 KB

and the final output will be in datatable
Output:
dt_Final

image
image249×122 2.01 KB

Anyone help me writing linq query for the above scenario.Thank you

2

Hi @yashashwini2322

Use below query

DT = (From row In DT.AsEnumerable()
              Where arrStr.Contains(row("ColumnB").ToString)
              Select row).CopyToDataTable

The image shows a workflow sequence for an Excel automation task, which includes assigning string values, reading a range from an Excel workbook, modifying data, and writing the results back to the workbook. (Captioned by AI)
The image shows a workflow sequence for an Excel automation task, which includes assigning string values, reading a range from an Excel workbook, modifying data, and writing the results back to the workbook. (Captioned by AI)818×612 32.9 KB

Input:

The image shows an Excel spreadsheet with two columns labeled "ColumnA" and "ColumnB," containing various text entries such as "CS," "SM," "required," and "not required." (Captioned by AI)

Output:

An Excel spreadsheet with two columns labeled "ColumnA" and "ColumnB," containing four rows of data with codes in ColumnA and corresponding status messages in ColumnB. (Captioned by AI)
An Excel spreadsheet with two columns labeled "ColumnA" and "ColumnB," containing four rows of data with codes in ColumnA and corresponding status messages in ColumnB. (Captioned by AI)695×398 4.79 KB

Regards,

3

Hi,Thanks for the query help but,same linq query is not working for the below table.Any modification needed for query.

image

4

@yashashwini2322

I’ve changed the query, try this

DT = (From row In DT.AsEnumerable()
              Where arrStr.Any(Function(str) row("ColumnB").ToString.ToLower().Contains(str.ToLower()))
              Select row).CopyToDataTable()

Regards,

6

@yashashwini2322

Try this

DT = (From row In DT.AsEnumerable()
      Where arrStr.Any(Function(str) row("ColumnB").ToString().ToLower().Contains(str.ToLower()) AndAlso
                                   row("ColumnA").ToString().ToLower() = "cs"
      Select row).CopyToDataTable()

Regards,