Column_1 Values lookup based on a value and return the adjacent value from column_2

Column_1 Values lookup based on a value and return the adjacent value from column_2

SamkSamk Posts: 6Questions: 2Answers: 0

Link to test case: https://live.datatables.net/zalitado/13/edit

any one know of a way to implement something like a "Vlookup" in the above testcase. i want to return the CPTY value with the Max,Min,and Average Values derived. any pointer in the right direction also appreciated. thanks in advance!

Answers

  • allanallan Posts: 63,431Questions: 1Answers: 10,457 Site admin

    You could use the row selector as a function (row-selector) which will let you select a row by data, then use row().data() to get the data for the whole row.

    e.g.:

    var rowData = table.row((idx, data) => data.myColumn === 'myMatch').data();
    

    Allan

Sign In or Register to comment.