Using the Transformation Command Edit View, you can create a new command file, open an existing command file, or save changes to a command file. The default command file is named "Manifest.txt."
You can create a new command, remove a command, replace a command with edited information, or change the order of a command.
Note: The command file is automatically saved whenever the commands table is updated.
Creating a command
To create a new command, do the following:
- Specify the source file, either a character-separated variable format file (with a .csv extension) or an XML format file (with a .xml extension).
- Specify the XML schema file to be used in the transformation.
- Specify the name of the output file to be created or modified during the transformation process (that is, where the new data will be stored), either an XML format file (with a .xml extension) or a character-separated variable format file (with a .csv extension).
- Specify a command mode.
Select Create if the output file is to be created or Append if the output data is to be appended to an existing data file.
- Click the Add row icon.
Removing a command
To remove a command, do the following:
- Select a command.
- Click the Remove row icon.
Editing or replacing a command
To edit or replace a command, do the following:
- Click the Edit command icon.
The row data is filled in for the appropriate input fields.
- Change the text in the appropriate input fields.
- Click the Replace row icon to update the row.
Moving a command one row up
To move a command one row up, do the following:
- Select a command.
- Click the Move row up icon.
Note: This changes the transformation-process sequence.
Moving a command one row down
To move a command one row down, do the following:
- Select a command.
- Click the Move row down icon.
Note: This changes the transformation-process sequence.
Clearing a command
To clear a command, do the following:
- Select a command.
- Click the Clear input fields icon.
This clears the text in the source-file, schema-file, and output-file fields.