Max/Mini Value in datatable by comparing with other datatabl

Question

I have two datatables table1 and table 5
Table1

Par Name	Lowest	Highest	lower_limit	upper_limit
Con_3			-0.65	0.03
Con_2			-0.12	0.06
Con_1			-0.41	0.02

Table5

Con_1	Con_3	Con_2	Split	Die_ID	Normal_Inverse
0.0013	0.0018	0.0012	Stressed	N6K83_12	-2.49897
-0.0071	0.0015	-0.0005	Ref	N634-10_12	-2.16681
-0.0004	0.082	-0.0027	Stressed	N610_15	-1.97699

I want to compare lower limit and upper limit from table 1 with corresponding column (Con_1,Con_2,Con_3 from table 5 ) and delete the column in table5 if :

There is no value lesser then lower_limit OR there is no value greater than upper_limit in the table5 column

Vulpes · Answer

Assuming all numeric columns are of type double, then try: foreach(DataRow dr in table1.Rows) { string colName = dr["Par Name"].ToString(); if(table5.Columns.Contains(colName)) { double lower = (double)dr["lower_limit"]; double upper = (double)dr["upper_limit"]; double min = table5.Rows.Cast ().Min(r => r.Field (colName)); if (min >= lower) { double max = table5.Rows.Cast ().Max(r => r.Field (colName)); if (max } } } or, if they're all strings, try: foreach(DataRow dr in table1.Rows) { string colName = dr["Par Name"].ToString(); if(table5.Columns.Contains(colName)) { double lower = double.Parse(dr["lower_limit"].ToString()); double upper = double.Parse(dr["upper_limit"].ToString()); double min = table5.Rows.Cast ().Min(r => double.Parse(r.Field (colName))); if (min >= lower) { double max = table5.Rows.Cast ().Max(r => double.Parse(r.Field (colName))); if (max } } }

Farhan Shariff · Answer

Thank you vulpes . works perfect only thing is I had to remove the last three columns from table5 ( Split , Die_id and normal inverse ), since I am adding it later again no problem :)

Khan Abrar Ahmed · Answer

Hi, what basis u want to match the rows?? please explain little bit more.