Consider the table below
<tbody>
</tbody>
as an example i have added just four rows but actual data contains millions of rows. I want to pick the column header of the minimum value. e.g. in ROW1, COL1 and COL3 has minimum value so 'EXPECTED RESULT' columns is populated with relevant columns.
COL1 | COL2 | COL3 | COL4 | EXPECTED RESULT | ||
ROW1 | 100 | 200 | 100 | 300 | COL1, COL3 | |
ROW2 | 200 | 100 | 50 | 400 | COL3 | |
ROW3 | 100 | 100 | 100 | 100 | COL1,COL2,COL3,COL4 | |
ROW4 | 900 | 900 | 900 | 900 | COL1,COL2,COL3,COL4 | |
<tbody>
</tbody>
as an example i have added just four rows but actual data contains millions of rows. I want to pick the column header of the minimum value. e.g. in ROW1, COL1 and COL3 has minimum value so 'EXPECTED RESULT' columns is populated with relevant columns.