Merge two or more tables based on specified matching and merging criteria.
This procedure generates a merged table by combining data from multiple tables based on user-specified merge criteria. You can designate a master table and a working table and define how rows should be matched (exact or fuzzy match). Additionally, you can configure which columns to include or exclude, how to treat similarly named columns, and whether to sort the columns in the final output.
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
This phrase should be written on a new line.
✅ Yes — This phrase is required.
❌ No — This phrase does not require data.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Table References need to be provided.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Replace x with a reference to a table.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Replace y with a reference to a table.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Replace column1, column2, column3, etc. with the names of the columns.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Replace column1, column2, column3, etc. with the names of the columns.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Replace column1, column2, column3, etc. with the names of the columns.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Replace column1, column2, column3, etc. with the names of the columns.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Replace column1, column2, column3, etc. with the names of the columns.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Replace column1, column2, column3, etc. with the names of the columns.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Replace b with a reference to a table.
Indented under create a merged table with.
❌ No — This phrase is optional.
✅ Yes — Use either "on" or "off". Default value is "on", if not specified.
the master table is the abovethe working table is the abovecreate a merged table with
the tables are the above tablescreate a merged table with
the tables are the above tables
the excluded columns are "FRIEND", "FOE"
the similar columns are "ALIAS" and "NAME", "MONEY" and "WORTH"create a merged table with
the tables are the above tables
the sort columns is "off"open a master table at "s3://my-bucket/data/master_table.xlsx"
open a working table at "s3://my-bucket/data/working_table.xlsx"
open a blacklist table at "s3://my-bucket/data/blacklist_table.xlsx"
create a merged table with
the master table
the working table
the master fuzzy match columns are "name", "age"
the working fuzzy match columns are "nom de guerre", "life span"
the master exact match columns are "address"
the working exact match columns are "location"
the blacklist tablethe blacklist table is the abovethe sort columns is "off"