Combine Worksheets (Merge)

SAP Agile Data Preparation allows users to create a new worksheet using all the columns from multiple worksheets.

The merge method is useful for a variety of purposes. For example, you could enrich the data in a worksheet by adding values from other worksheets over a period of time. Another example could be to merge worksheets that may contain the same data from multiple sources to track trends. To merge the columns of different worksheets together, follow the steps below.

  1. Navigate to the worksheet that you wish to use as the base worksheet to merge data with.
  2. Click the + icon next to the worksheet tabs and select Combine Worksheets in the drop-down menu.
  3. Select Merge in the dialog box that appears.
  4. Select the worksheet to combine with your current worksheet.
  5. Click Next.
  6. The interactive diagram on the left-hand side shows a tree structure representation of the worksheets you have combined. Each white node represents a worksheet and each gray node indicates a join operation. Changes made to the tree structure will be automatically updated on the right-hand side and vice versa.
  7. If you choose to combine another worksheet from a node on the tree diagram:
    1. Select the down arrow next to a node on the tree diagram to which you want to combine the new worksheet.
    2. Select Combine <selected worksheet name> With Another Worksheet .
    3. In the dialog box that appears select the worksheet you wish to combine to the current worksheet or your current join.
    4. Select the position to place the selected worksheet in relation to your current worksheet or your current join. If you select Use this worksheet on the LEFT side, the columns of the selected worksheet will be placed on the left side of the current worksheet or your current join, and vice versa.
    5. Click OK.
  8. When modifying a join operation, select a Join Type.
    You can select one of the three join types:

    • Inner Join - Includes only matching rows from both worksheets

    • Left Outer Join - Includes all rows from the left worksheet

    • Full Outer Join - Includes all rows from both worksheets

  9. Click the icon next to Join Condition to select columns to match from the list of suggested joins or manually select the join columns to merge. The Match Percentage bar indicates how strong a match the join condition is.
  10. (Optional) Select the operator between two columns to change the join condition to a non-equal operator.
  11. (Optional) Add more join conditions by clicking the Add New Join Condition button.
  12. Click the Select Output Columns tab to select the columns you want to appear in your combined worksheet. Select a column header to rename or remove the output column. You can also drag and drop the output column headers to reorder them.
  13. Once you have configured the worksheet layouts to your satisfaction, select Combine Worksheets.
  14. Enter a name for the new combined worksheet. Optionally include a description.
  15. Click Create.

    A new worksheet is created with your combined data.