Hello! I have put some sets of data into two datatables, and I want to compare the data tables to see if they have the same values in them (the order of the rows doesn’t matter, and I only need to know if ALL the data is the same or not - I don’t need to know what is different)
DT1 has data from a spreadsheet
DT2 has data from the system
At present I am sorting both datatables by the first column (which is unique), and then using “Output Data Table” to output both data tables as a string, and then comparing the string using IF DT1str=DT2str
Is this the best way to do this, or is there a “better” way?
I’ve tested out my solution, and it doesn’t seem to fail.
I suspect it is quicker than a for each loop when I don’t care about individual values - just the DT as a whole.