To insert rows from file:
Select Insert > Rows....
If you have more than one data table in the document, select which data table to add columns to, then click Next.
Click the File radio button.
Click Browse... to locate the file to add columns from, then click Open.
Response: If the selected file is a text file, the Import Settings dialog is displayed. If the selected file is an Excel file, the Excel Import dialog is displayed. Optionally, make the desired adjustments in the dialog, then click OK.
Apply transformations (optional).
Comment: See Transforming Data to learn more.
Click Next > to go to the Match Columns step of the wizard. (If you want the columns to be matched automatically, go straight to step 11 instead.).
Click on the Match All Possible button, or manually select one column From current data and one From new data and click Match Selected. Repeat if necessary.
Comment: The columns used for matching should together create a unique identifier for all rows.
Click Next > to go to the Additional Settings step of the wizard.
If the new data contains more columns than the original data table, you may add the new columns by selecting their check boxes.
If desired, you can add information about the origin of new rows to a specified column.
Comment: Update existing column is only relevant when rows have been previously added to the document.
Click Finish.
Response: The selected columns are added to your data table.
To insert rows from information link:
Select Insert > Rows....
If you have more than one data table in the document, select which data table to add columns to, then click Next.
Click the Information Link radio button.
Click Browse... to locate the information link to add columns from.
Response: The Select Information Link dialog is displayed.
Locate and select the information link of interest, and then click OK.
Apply transformations (optional).
Comment: See Transforming Data to learn more.
Click Next > to go to the Match Columns step of the wizard. (If you want the columns to be matched automatically, go straight to step 12 instead.)
Click on the Match All Possible button, or manually select one column From current data and one From new data and click Match Selected. Repeat if necessary.
Comment: The columns used for matching should together create a unique identifier for all rows.
Click Next > to go to the Additional Settings step of the wizard.
If the new data contains more columns than the original data table, you may add the new columns by selecting their check boxes.
If desired, you can add information about the origin of new rows to a specified column.
Comment: Update existing column is only relevant when rows have been previously added to the document.
Click Finish.
Response: The selected columns are added to your data table.
To insert rows from a database:
Select Insert > Rows....
If you have more than one data table in the document, select which data table to add columns to, then click Next.
Click the Database radio button.
Click on Browse... to locate the database with additional data.
Response: The Open Database dialog is displayed.
Follow the instructions for the desired data source type under Opening Data from a Database.
Apply transformations (optional).
Comment: See Transforming Data to learn more.
Click Next > to go to the Match Columns step of the wizard. (If you want the columns to be matched automatically, go straight to step 12 instead.)
Click on the Match All Possible button, or manually select one column From current data and one From new data and click Match Selected. Repeat if necessary.
Comment: The columns used for matching should together create a unique identifier for all rows.
Click Next > to go to the Additional Settings step of the wizard.
If the new data contains more columns than the original data table, you may add the new columns by selecting their check boxes.
If desired, you can add information about the origin of new rows to a specified column.
Comment: Update existing column is only relevant when rows have been previously added to the document.
Click Finish.
Response: The selected columns are added to your data table.
See also:
Details on Insert Rows – Select Source
Details on Insert Rows – Match Columns
Details on Insert Rows – Additional Settings