Question

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

  • 10 August 2022
  • 2 replies
  • 17 views

Badge +6

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


2 replies

Badge +4

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

Badge +6

My mind is blown - thank you!

Reply