The Transformer lets you scan the original value in the attribute and change, copy, move, or delete the value or set a value in a different attribute.
Scan attributes - Attribute Scan Wizard
To scan attributes - Attribute Scan Wizard
- From the Navigation or Project View, right-click the Transformer process and select Edit Process. You can also double-click the process to open it for editing.
- Select the Output Conditionals tab.
- Right-click within the Output Transformations pane (right-hand side) and select Add > New > Attribute Scan. The Attribute Scan - Step 1 Wizard displays. There are a total of three (3) steps to complete the attribute scanning settings.
Complete Attribute Scan - Step 1
To complete Attribute Scan - Step 1
Complete Attribute Scan - Step 2
To complete Attribute Scan - Step 2
- Specify How much of the attribute should be scanned. This indicates the location of the value for which to scan: the exact Beginning of the attribute, anywhere in the attribute (Entire Attribute) (default), or the exact End of the attribute. If you are using delimiters then Entire Attribute will be selected automatically.
- Specify in which direction the attribute should be scanned, either from Left-to-Right (default), or from Right-to-Left. This setting only applies if you are scanning the entire attribute.
- (Optional) If you select Beginning or End and you want to scan the beginning or the end of the text instead of the attribute, select Ignore leading/trailing spaces.
- Specify the function to perform if scan value is found in the attribute. You can Change, Copy, Move, or Delete the value or set a value in a different attribute (Flag).
- Click Next. Depending on the selection of the function to perform, the options in Step 3 are different.
Complete Attribute Scan - Step 3
To complete Attribute Scan - Step 3
Refer to the following table to complete Step 3.
Note: The British Pound (£) and the Not sign (¬) characters
are not supported as delimiters in Quality processes.
To... Action Change
- In Enter new Value, enter the user-defined value that replaces the scan value.
- For No. of Occurrencesto change, specify All or 1 or Other numeric value that indicates how many times you want to scan and change the value within the scan attribute.
Flag
- In Select target attribute, select the attribute whose value will be changed.
- In Value to be stored in target attribute, specify the value to be stored in the target attribute.
Copy
- In Select target attribute, select the attribute to which the value will be copied.
- In What would you like to copy?, specify the elements of the attribute you want to copy. Use the Preview area to help you select the correct option.
- In Character used to separate each word, specify the delimiter used to separate words within an attribute. This only applies if you selected one of the options that operates at word level in Step 2. If the delimiter is not on the list, select Other and specify the character in the field.
Move
- In Select target attribute, select the attribute to which the value will be moved.
- In What would you like to move?, specify the elements of the attribute you want to move. Use the Preview area to help you select the correct option.
- In Character used to separate each word, specify the delimiter used to separate words within an attribute. This only applies if you selected one of the options that operates at word level in Step 2. If the delimiter is not on the list, select Other and specify the character in the field.
- If you want to keep the scan value in the scan attribute, check the Retain scan value in scan attribute check box.
Delete
- In What would you like to delete?, specify the elements of the attribute you want to delete. Use the Preview area to help you select the correct option.
- In Character used to separate each word, specify the delimiter used to separate words within an attribute. This only applies if you selected one of the options that operates at word level in Step 1. If the delimiter is not on the list, select Other and specify the character in the field.
Click Finish.