Comparing Two Datasets Values, and using those to determine difference

Try this one, modify the script to fit your needs:

Compare Datasets_2019-04-15_1605.proj (11.5 KB)

editTable = event.source.parent.getComponent('Edit Table')
masterTable = event.source.parent.getComponent('Master Table')

editData = editTable.data
masterData = masterTable.data

editSet =set(tuple(row) for row in system.dataset.toPyDataSet(editData))
masterSet =set(tuple(row) for row in system.dataset.toPyDataSet(masterData))

print editSet
print masterSet
print editSet - masterSet

1 Like