Using Japanese Itai Table - trillium_discovery - trillium_quality - 17.2

You can convert the Japanese Itai characters to the standard characters by using the table recode function. The default itai table and its schema (ddx) are provided in: C:/Program Files/Trillium Software/MBSW/17/tsq/tables/general_resources.

To convert the Japanese itai characters

1. 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.
2. Select the Output Conditionals tab.
3. Right-click within the Transformation Rules pane (right-hand pane) and select Add > New > Table Recode.
4. Enter a description for this table recode operation. The description will be inserted in the statistics file.
5. Select File as the source of recodes.
6. Click Upload from client and select the itai table (itai.txt) and its schema (itai.ddx) from the tables\general_recources directory.
7. Select Comma for the Delimiter.
8. Select Use Phrase Separator.
9. Select Any for the Phrase Separator.
10. Select Anywhere in phrase for the Look-up Position.
11. Click Next.
12. Select the attribute from the Match attribute list. This is the attribute in the output where the Transformer looks for the original value.
13. Select the Itai attribute from the to recode attribute list. This is the attribute in the itai table where the original itai values are described.
14. Select Literal for the type of the value.
15. Click Next.
16. Select the Standard attribute from the Copy recode attribute list. This is the attribute in the table that contains the standard values.
17. Select the attribute from the to attribute list. This is the attribute in the output which is used to store the recode value from the recode table.
18. Select Literal for the type of the value.
19. Click Finish.