Vlookup
- Lookup Column: The column to look up in the Lookup Table. Make sure the column is named the same in both tables.
- Lookup Table: The table to look up the Lookup Column in.
- Keep Columns: The columns to keep from the Lookup Table. If not provided, all columns from the Lookup Table will be kept.
- For values that don't find a match in the lookup_column, you will see Null
- For columns that have the same name in both tables, the columns in the Lookup Table will be prefixed with the table name
Name | Type | Description | Is Optional |
---|---|---|---|
lookup_column | column | Column to look up in the lookup table | |
lookup_table | table | Table to look up the lookup_column in | |
keep_columns | column_list | Columns to keep from the lookup table | True |
internet_sales = rasgo.get.dataset(74)
customer = rasgo.get.dataset(55)
product = rasgo.get.dataset(75)
ds2 = internet_sales.vlookup(
lookup_column='PRODUCTKEY',
lookup_table=product.fqtn,
keep_columns=['WEIGHT', 'ENGLISHDESCRIPTION']
)
ds2.preview()
Last modified 7mo ago