A360 - Data Table: exclusionary join? (Only return records that do not match)

  • 10 August 2022
  • 2 replies

Userlevel 3
Badge +9

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.



2 replies

Userlevel 3
Badge +6

@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.

Userlevel 3
Badge +9

My mind is blown - thank you!