Question

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

Userlevel 3

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

Thanks

Userlevel 3

+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

+9

My mind is blown - thank you!

Sign up