Diff of 2 datatables

hpegmslicensemgmt

Dear all,
Is there a clever way to get the difference between 2 DataTables ?

2 Tables with the same structure and similar content where Table A can have different entires of Table B ...

Best regards,
David

kthorngren

You can use rows().data(), possibly with toArray(), to get all the data in the Datatable. Use a loop to iterate the both sets of data to compare for differences.

Kevin

kthorngren

Any sorting or searching that is applied differently between the two tables might affect the order the row data is traversed. See the selector-modifier docs to choose the appropriate options for your solution.

Kevin

rf1234

Any sorting or searching that is applied differently between the two tables might affect the order the row data is traversed.

Right! Here is something from my own coding sorting the data so that that they can be compared and eventually diffed.

var sRows = dt.rows().data().toArray();
sRows.sort(function(a,b) {
    return a.DT_RowId.localeCompare(b.DT_RowId);
});