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
internet_sales = rasgo.get.dataset(74)
product = rasgo.get.dataset(75)
​
ds2 = internet_sales.join(
  join_table=product,
  join_columns={'PRODUCTKEY':'PRODUCTKEY'},
  join_type='LEFT',
  join_prefix='product',
  filters=['CUSTOMERKEY IS NOT NULL', 'ORDERDATE < CURRENT_DATE()'])
​
ds2.preview()
Source Code
RasgoTransforms/join.sql at main · rasgointelligence/RasgoTransforms
GitHub

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

If Then

Joins

Last modified 1yr ago