SQL Function in Excel automation

[vvaidya (Vinay Vaidya)]

add datacolumns new value and y/n to DT1

Foreach DT 1 row
{

rowArray = DT2.Select("Max> int.parse(row(2).Tostring) and Min<int.parse(row(2).Tostring())

you will get row array here (1 row)—> get new value and y/n

row(“newvalue”)= newvalue from rowarray;
row(“y/n”)= y/n from rowarray;

}