Hi @krishnan,
Assume the datatable as dt1 and dt2.
Using for each row activity Loop it dt1
In side for each row body check if condition like
Dt2.select("column1=row(“column1”).tostring). length>0
If success the first table column value match into second table.
Regards,
Arivu
i tried this but I get compilation error disallows implicit conversion to Boolean to string.can you help on it.
I have 2 datatables
firstdt
column1 column2
1 ABC
2 DEF
seconddt
column1 column2
01 DEF
02 ABC
Now I wanted to compare firstdt column2 with seconddt. column 2 and have the count of match and mismatch.
can you give me the complete logic for this ?
Dt2.select("column1=row("column1").ToString").length>0
can you try this one
Regards,
Arivu
tried still getting error.
Send screenshot of your for each activity and what error you are getting?
Sorry while typing it went something wrongly please use below code to check if condition
Dt2.select("column1='"+row("column1").ToString+"'").length>0
Regards,
Arivu
hi can you give me the full code for the above.
The value of row(column1) will be 15 characters.(need to pick the 8 characters from 3rd postion)
the value of dt2.column1 will be 8 characters.
I want to compareas follows:.
d2.column1 rrow(column1)
can u help on it?
@krishnan
use this Query
(From p in dt1.AsEnumerable
where ( From q in dt2.As Enumerable()
where (Convert.ToString(q.Item("column1)).Substring(2,8)).Equals((Convert.ToString(p.Item(“Column1”)))
Select q).ToArray.Count>0
Select p).ToArray.Count
It will give you the matched rows count of dt1 and if you want unmatched rows use dt1.Rows.Count-Count of matched rows
Regards
Mahesh
Hi @krishnan,
Dt2.select("column1='"+row("column1").ToString.SubString(2,8)+"'").length>0
Regards,
Arivu
dt2.column = 15 charaters
dt1 column = 8 characters
comparison should be done as follows
dt1 column = dt2.column(8 characters should be picked here
can you give the query for this?
Hi @krishnan,
try this
Dt2.select("column1 like '___"+row("column1").ToString+"%'").length>0
Regards,
Arivu
this does not work.Can you give me a simple query for this?
@krishnan
did you try this
From p in dt1.AsEnumerable
where ( From q in dt2.As Enumerable()
where (Convert.ToString(q.Item("column1)).Substring(2,8)).Equals((Convert.ToString(p.Item(“Column1”)))
Select q).ToArray.Count>0
Select p).ToArray.Count
It will give you the matched rows count of dt1 and if you want unmatched rows use dt1.Rows.Count-Count of matched rows
Regards,
Mahesh
Hi @krishnan,
Use this code
From p in dt1.AsEnumerable
where ( From q in dt2.As Enumerable()
where (Convert.ToString(q.Item("column1)).Substring(2,11)).Equals((Convert.ToString(p.Item(“Column1”)))
Select q).ToArray.Count>0
Select p).ToArray.Count
Regards,
Arivu
Hi Everyone,
I need to compare two column like (column1 is A, B, C, and column2 is B, D, E, C, A) when column1 “A” it will search if there is A in the column2.
Use the below code to get only the matched data from the Column
From p in dt1.AsEnumerable where ( From q in dt2.As Enumerable() where (Convert.ToString(q.Item("column1))).Equals((Convert.ToString(p.Item(“Column2”))) Select q).ToArray.Count>0 Select p)
can you tell me how u want the result?
Sorry… I have one difficult sample same same with to this topic but between Excel & PPT file as below link.
Pls support me this sample by XAML file.
thanks you !