Join
Join a dataset with another dataset, by matching on one or more columns between the two tables.
If you pass a join_prefix, all column names in the join table will be named "{join_prefix}_{columnname}". If you don't pass a join_prefix, columns that share the same name in both tables will be only have the column from the base table included in the final output.
Parameters
Name | Type | Description | Is Optional |
---|---|---|---|
join_table | table | Dataset object to join with the source dataset. | |
join_type | join_type | LEFT, RIGHT, or INNER | |
join_columns | join_dict | Columns to use for the join. Keys are columns in the source_table and values are on columns in the join_table. | |
join_prefix | value | Prefix all columns in the join_table with a string to differentiate them | True |
filters | filter_list | Filter logic on one or more columns. Can choose between a simple comparison filter or advanced filter using free text. | True |
Example
Source Code
Last updated