Could you maybe provide the Expected Output for the above provided Input data as well. So that we could be sure as to the logic that we would be applying.
@kavya.s16
we do have some doubts on the requirement description and the mentioned output.
When the output is only 100 then it is more a hint to match / inner join case
dtOuput = dt1.Clone
dtOutput =
(From d1 in dt1.AsEnumerable
Join d2 in dt2.AsEnumerable
On CDbl(d1(0).toString) Equals CDbl(d2(0).toString
Let ra = new Object() {CDbl(d1(0).toString)}
Select r = dtOutput.Rows.Add(ra)).CopyToDataTable
Okay !! let me elaborate
As mentioned above those are the two datatables!!
For datatable1 apply replace comma with “”
then
I need to loop through Datatable2
then apply => left(1680000.00,6) (6, bcoz len -3 so 9 minus 3 =6) output = 168000
then will have to check whether this is there in datatable1