Home
Combination of data sets
Includes recipes on types of links, expansions, merges, creating additional data, and more.

Combination of data sets
Includes recipes on types of links, expansions, merges, creating additional data, and more.
- Linking to find all possible values of a column
  By duplicating each row in the base table, you can accommodate all matches in the foreign table when linking the two tables together on a common column.
- Combining rows of multiple tables
  You can efficiently combine the rows of multiple tables that are located in the same folder and have the same columns using <loop>. The result will be a single worksheet containing the rows from each table.
- Finding missing values by linking tables
  When merging tables, sometimes they do not have equal amounts of information. When using match="pad", the columns that do not have matches are populated with NA values for the foreign table. To find the missing values that are added when tables that have unmatched columns, you can create a reference or lookup table.
- Adding source information to the description of columns
  By using <loop>, you can add the path of the originating table to the description of each linked column, when combining the columns of multiple tables.
- Checking for common column names among tables
  Using <loop> makes it easy to perform multiple identical operations. Instead of previewing multiple tables to decide which column to link on, you can determine which tables contain columns with matching names by looping through a directory folder.
- Linking columns of tables on closest match
  Sometimes it is necessary to combine tables on a common column that do not contain exact matching information. You can combine tables using an asof link that matches rows with their nearest value.
- Determining if two tables match
  You can determine if two tables contain the same information by comparing the columns of one table to the columns of a second table.

Combination of data sets

Includes recipes on types of links, expansions, merges, creating additional data, and more.