Description
Keep only rows from the top dataset with key values that are present in the lower dataset.
Example
Keep rows in the top dataset that also have their ids in the bottom dataset:
Inputs
Two.
Options
•The output depends on the vertical (Y-axis) position of the inputs.
•Click Explore Keys... to compare key values in the 2 datasets.
•Select Top key column for the column you want to match in the top input dataset.
•Select Bottom key column for the column you want to match in the bottom input dataset.
•Check case sensitive to use case sensitive matching for keys.
Notes
•If there are 10k rows or less in both datasets, Easy Data Transform will try to guess sensible default values for Top key column and Bottom key column based on column header names and contents.
•If the first input has a header, this will be used for the output.
•All values are treated as text and comparisons are whitespace sensitive. You can use Whitespace to remove whitespace before the intersect.
•Does not remove duplicates. You can use Unique to do this.
•You can use Concat Cols to join several columns together (e.g. 'first name' and 'last name' columns) to form a key column.
•You can use Row Num to create a unique key column.