If a second worksheet is used, then the Sort Map worksheet may be needed to map the column names of Worksheet 1 and Worksheet 2, if they differ. This will allow rows in both worksheets to be merged based on their sort keys. The Worksheet 1 Sort Keys and Worksheet 2 Sort Keys pull-down menus are populated with the names of the columns defined as Sort keys on each worksheet’s mapping panel. Required input is highlighted orange in the interface.
The Sort Map will automatically map columns of the same name. If there is not a matching name for a Worksheet 1 column, the Worksheet 2 column name will be blank.
Legal Notice | Contact Certara
© Certara USA, Inc. All rights reserved.