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.
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.