Populating analytical query transformations

After you finish building the structure of your analytical query, you populate it with data sets.

1. In the Analytical query structure, select a transformation node that you want to populate with data.
   In the Item editor pane, you can view the items of the selected transformation.
2. From the Repository Explorer tree, navigate to a query or table that you want to add and drag it to a <none> node under the selected transformation node or directly into a corresponding column list in the transformation layout.
   The columns of the selected data set are now displayed in the Item editor pane. The display of the columns depends on the type of the transformation that uses these columns.

   Note: If you select a <none> node, you can drag a query or table anywhere in the blank area in the Item editor pane.

   Note: You can drag a table or a query to a node that is already populated. This will replace the current data set with the new one.

   Note: If you drag a table or a query to the transformation node, the transformation will be replaced with this table or query and the structure of the transformation will be lost.
3. To add a query that is currently open in a separate editor, right-click a <none> node in the analytical query structure, navigate to Add from Opened... and select one of the available queries.
4. To add a query that is saved in a data file:
   1. Right-click a <none> node.
   2. Select Add Query.
   3. Select Open from File and click Next.
   4. Browse for the query that you want to add and double-click it.
   5. Click Finish to close the Open from File wizard.
   The query from the data file is added to the analytical query structure.
5. To add a table that is saved in a data file:
   1. Right-click a <none> node.
   2. Select Add Table.
   3. Select Open from File and click Next.
   4. Browse for the table that you want to add and double-click it.
   5. Click Finish to close the Open from File wizard.
   The table from the data file is added to the analytical query structure.
6. To replace a query or table in the node with one of the queries that are opened in separate editors, select the node, click the Change to... icon. Navigate to Change to Opened... and select one of the available queries.
7. To replace a query or table in the node with a query or table from a data file:
   1. Select the node.
   2. Click the Change to... icon.
   3. Navigate to Change to Query or Change to Table.
   4. Click Yes in the Change Item window if you agree to continue.
   5. Select Open from File and click Next.
   6. Browse for the query or table that you want to add and double-click it.
   7. Click Finish to close the Open from File wizard.
8. To rename a table or query, select it and click the Rename icon. Specify the new name for the query or table in the Query name field and click OK.
9. To detach a table or query, select it and click the Detach icon. A copy of the query or table opens in a separate editor. Any changes to this object have no effect on the analytical query that it was taken from.
10. To open and edit a query or table in a separate editor, select it and click the Open in Separate Editor icon. The query or table opens in a separate editor. Any changes to this object have a direct effect on the analytical query that it was taken from.
    Note: You cannot view a query or table in the Item editor while it is opened in a separate editor.
11. You can create notes for any of the structure nodes in the Note section under the Analytical query structure:
    1. Select a structure node for which you want to enter a note text.
    2. Click anywhere in the Note section.
    3. Edit the existing note text or enter a new text.
    4. Save the changes to the note for the selected structure node by clicking Save.
    When you highlight the structure node, you can view the new text in the Note section.

    Note: Replacement of an element in the structure resets the note for the respective node to empty or changes the note text to the text of the newly selected analytical query.