Merge DAT

Summary

The Merged DAT is a multi-input DAT which merges the text or tables from the input DATs together.

Parameters

How /how - Sets how tables are merged together.

• Append Rows - Merges tables together by adding rows from subsequent tables to the first table. If the By Name option is used, then data from subsequent tables will be added to the column with the same name, and the first row will not be added. If the subsequent tables have more columns than the input table, they will be appended.
• Append Columns - Merges tables together by adding columns from subsequent tables to the first table. If the By Name option is used, then data from subsequent tables will be added to the row with the same name, and the first column will not be added. If the subsequent tables have more rows than the input table, they will be appended.
• Concatenate Rows - Merges tables together by concatenating all cells in a column into one single cell. You will have one row and one or more columns at the end.
• Concatenate Columns - Merges tables together by concatenating all cells in a row into one single cell. You will have one column and one or more rows at the end.
• Concatenate Cells - Merges tables together by concatenating all cells together. You will have one single cell at the end.
• Replace Rows - Replaces data in the first table with data in subsequent tables, matching by column names. Data from the last table will always be used.

For example, if your first input table is

 Name          Species	  Age
 Birch	        Ferret	  6
 Diefenbaker	Ferret	  4

and you have two more input tables in the order

 Name          Species	   Age
 Birch	        Ferret	   5
 Diefenbaker	Wolverine  5

 Name          Species	  Age
 Birch	        Ferret	   6
 Diefenbaker	Otter	   10

your output table will be

 Name          Species	  Age
 Birch	        Ferret	   5
 Diefenbaker	Otter	   10

• Replace Columns - Replaces data in the first table with data in subsequent tables, matching by row names. Data from the last table will always be used.

By Name /byname - Specifies if you are appending columns and rows by name.

Concatenate with /spacer - Allows you to separate the cell data with a string when concatenating. The default is a space.

Append Unmatched /unmatched - If the subsequent tables have rows or columns that are not found in the first table, these will be added to the output.