Using Japanese Itai Table - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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 Anywherein 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.