The Mappings panel allows users to specify which columns in a worksheet are involved in the worksheet transformation.
All instructions for setting up and execution are the same whether the object is viewed in its own window or in Phoenix view.Īdditional information is available for the following topics: Note: To view the object in its own window, select it in the Object Browser and double-click it or press ENTER.
Right-click menu for a worksheet: Send To > Data > Join Worksheet. Main menu: Insert > Data > Join Worksheet. Right-click menu for a Workflow object: New > Data > Join Worksheet.
Use one of the following to add an Join Worksheet object to a Workflow: Each one corresponds to inner and outer joins used in SQL (structured query language). The object can perform two types of joins: inner and outer.