Hi,
I’ve sheet with data. I find the max Price and based on the max price find the entire row.
How to do it ?
Thank u.
you mean find the maximum surcharge?
yes. max surcharge and it’s entire row data
Hi @Prinal_C
use below assign activity to filter the rows having max surcharge value
dt_result = dt1.AsEnumerable().Where(Function(row) row(“Surchage”).ToString(dt1.AsEnumerable().Max(Function(row) CDbl(row(“Surcharge”)).ToString).CopyToDataTable
Regards,
Nived N
Happy Automation