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
-
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 Transformation Rules pane (right-hand pane) and select Add> New > Table Recode.
-
Enter a description for this table recode operation. The description will be inserted in the statistics file.
-
Select File as the source of recodes.
-
Click Upload from client and select the itai table (itai.txt) and its schema (itai.ddx) from the tables\general_recources directory.
-
Select Comma for the Delimiter.
-
Select Use Phrase Separator.
-
Select Any for the Phrase Separator.
-
Select Anywherein phrase for the Look-up Position.
-
Click Next.
-
Select the attribute from the Match attribute list. This is the attribute in the output where the Transformer looks for the original value.
-
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.
-
Select Literal for the type of the value.
-
Click Next.
-
Select the Standard attribute from the Copy recode attribute list. This is the attribute in the table that contains the standard values.
-
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.
-
Select Literal for the type of the value.
-
Click Finish.