Understanding Manipulate Input File

Manipulate the file or format of the data from which you are loading data. The top pane displays the raw data, and the bottom pane displays the manipulated data. Manipulation options include:

• Join - merges multiple columns into a new column.
• Split - divides a column into multiple columns.
• Move - changes the display order of the columns.
• Sort - categorizes or sorts the data based on a specific column.
• Replace - finds and replaces for the selected column.
• Create - creates a new column with a user-defined value.
• Headers - allows the creation of column headings for the data.
• Manipulations - provides a view of all the manipulations applied to the data.

Description of Fields for the Manipulate Input File Page

Create: Create a new column on the Create page.

• Column Name - Enter the name of the new column.
• Column Value - Enter the row value for the column.

Copy: Select the column you want to copy and click Copy to open the Copy page where you will create two new columns.

Description of fields on the Copy dialog page:

Source Column - Select the column you want to copy and click Copy to create two new columns. When you copy a column, the Source Column contains information from the column you copied. Enter the name of the new column in which you will copy the contents to.

Grid Actions

Sort: Sort the columns.

Manipulations

Join: Join two columns into one column by providing a Join Column Name and Join Operator.

• Join Column Name - Select the columns you want to join by pressing the Shift key on your keyboard while selecting the columns. Enter the new name of the column you are creating with the join. For example, a Join Column Name might be COL3 for joined columns 1 (COL1) and 2 (COL2).
• Join Operator:
  • None - No join operator.
  • Underscore - Add an underscore. For example, if you add column 6 containing X with column 7 containing Y, the joined column 8 will contain X_Y.
  • Space - Add a space between the contents of the two joined columns.
  • Dot - Add a dot between the contents of the two joined columns.
  • Hyphen - Add a hyphen between the contents of the two joined columns.
    
• Add New - Add the newly joined column to the spreadsheet on the Manipulate Input File page.

Split: Split one column into two columns by providing Split at, Split Column Name 1, and Split Column Name 2 information.

• Split at - Select the column you want to split. Enter the point where the split will occur within the column.
• Split Column Name 1 - The name of the first column you are creating by performing the split.
• Split Column Name 2 - Enter the name of the second column you are creating by performing the split.
• Add New - Split the column and display the new columns on the spreadsheet on the Manipulate Input File page.

Move: Move the placing of the column up, down, to the top, or to the bottom of the grid. 

Replace: Replace a selected column name on the Replace page.

• Replace/With - Enter the information you want to replace (in the Replace field) with the information you are replacing it with (in the With
• field).
• Replace Entire Sheet - Replace the entire grid of columns. If this checkbox is not available, the replace will only happen for a selected column. By default, Replace Entire Sheet is deselected.
• Match Entire Cell Content - Replace partial text in a cell. Select this checkbox to replace only those cells where the cell contents exactly match with the content provided in the Replace (full text replacement). If you don’t select this checkbox, all cells where the text in content is used in partial or full will be replaced. By default, Match Entire Cell Content is deselected.

Data Headers: Edit or create the heading names of the columns on the Headers dialog page. Manipulated Columns provides information on the name of the columns. Header Columns provides the name of the headers, which can be edited.

Data Manipulations: View data manipulations on the Manipulations page.

• Order - Reverse the order of the columns.
• Operation - The operations defined (i.e. Split, Join).
• Join Operator - The join operators created when you performed the Join (underscore, dot, hyphen, or space).
• Source Columns - The columns copied from when you performed the Copy.
• Target Columns - The columns copied to when you performed the Copy.

Grid Action

Turn the row and column headers on or off.

Auto-Size Column Width - Automatically adjust the columns in the Raw Data and Manipulations Data grids to fit the contents.

The columns in the Manipulations grid may also be resized by dragging them to the right as you would in an Excel spreadsheet. The resized column settings are saved when you click Next or Finish.