Decimal places are standardized on the greatest number of places, with trailing zeros added to numeric values where necessary. A different number of defined decimal places are harmonized.The fields are converted to the ACL data type. Different field lengths are harmonized.Different character data types such as Custom, PCASCII, and EBCDIC are harmonized by converting the fields to the ASCII or UNICODE data type.In some situations Analytics automatically harmonizes fields in order to append them: Data category of fields If you include only common fields, the output table contains all the records and only the common fields from the three appended tables. If you include all fields, the output table contains all the records and all the fields from the three appended tables.īlank values appear in the output table where no fields exist in the source tables. The three tables being appended appear below: Table name The three tables have three common fields, which appear in every table:Īnd two non-common fields, which appear in one or more tables, but not in every table: You want to append three employee tables into an employee master table before performing analysis on employee data. include only those fields that are common to all source tables, meaning that they occur in every tableįor fields to be considered common they must have an identical physical name, and belong to the same data category:.include all fields from all source tables.When you append tables you have two options: Including all fields or only common fields While not the primary intended use of appending, there may be instances in which appending dissimilar tables serves an analytical purpose.

You can append completely dissimilar tables – that is, two or more tables that do not have any fields in common. With appending, all records from each source table are included in the output table. When appending is less suitableĪppending is generally not a substitute for joining or relating because it does not allow you to include or exclude records based on matched or unmatched values in a common key field. You append the data from the twelve monthly tables into a single annual table containing all the data, and then perform the analysis. You want to perform analysis on an entire year's worth of data but the data is spread among twelve monthly transaction tables. In the diagram below, fields A and E are examples of this method of appending fields. In the diagram below, fields A, B, and C are all directly appended.įields with physical names that are unique across all the source tables are added to the output table but not directly appended to any other field. Source table fields with identical physical names and identical data categories are directly appended to one another. When you append records from multiple tables, how the individual fields within the records are appended depends on whether the fields have identical names or unique names. The source tables can have different or identical record structures, and can be sorted or unsorted. The new table contains the records from the first selected table, followed by the records from the second selected table, and so on. The records from each source table are appended in the order in which you select the tables. How does appending work?Īppending adds one group of records to the bottom of another group of records.

After importing the individual worksheets into Analytics, you can then append them to create a single annual table for analysis. You may need to append multiple tables into a single table before you can perform analysis.įor example, you want to perform analysis on an entire year's worth of data but the data is spread among twelve monthly Excel worksheets. Appending tables combines records from two or more Analytics tables into a new table.

Apppending