Getting one value from a CSV file and then checking if that value exists in another CSV file

Help
1

Hi,

I am trying to assign a variable (say String) to a Select tag such as this ResultRow.Select(String). The result of the latter is then assigned to another variable (say DataRow) from DataTable2

I get this error: Cannot assign from type ‘System.Data.DataRow’ to type ‘System.Data.DataRow’ in Assign activity ‘Assign’.

The String above is taken from another data tabke (DataTable1).

Essentially, what I am need to do is open 2 CSV files, get one value from CSV1 (DataTable1) and then compare if that value exists in CSV2 (DataTable2)

Hope anyone can help.

image
image1920×1080 348 KB

2

Hey @aye

Change your filteredRows variable Datatype to System.Data.Datarow[ ] i.e. means select datatype Array of [T] then select String.

because ResultRow.Select(String) will always returns an array of datarow.

Regards…!!
Aksh

3

thank you @aksh1yadav !

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.