Is there a way to join two data tables so that the resulting table does not contain any of the records in the second table?
This would be the equivalent of a left, right, or inner exclusionary join in SQL.
This would be immensely helpful to me as I am trying to quickly remove all of the records in one CSV from another CSV.
Thanks
@Logan Price A360 - Data Table is very limited.
Better approach for CSV files is to use database package and perform required JOIN using SQL queries directly.
You can access CSV as a table directly, similar to excel as database.
My mind is blown - thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.