Creating PDW Translate Statements
Use translate statements to manipulate the data elements you are importing
before storing the data in the PDW or manipulate the metadata items you
are exporting before you update the Eclipse Product file.
Use the PDW Translation Table to:
For example, you can translate a data provider's
units of measure to Eclipse units of measure.
For example, you can combine the data provider's
6-digit vendor ID with the 5-digit NAED number for a product to create
a UPC number. Or you might append a 6-digit prefix that identifies the
vendor to a product's NAED number to create a UPC number.
-
Display the import
layout or export layout you are defining.
-
Select the item in the Data Identifier column for which
you want to create a translate statement.
-
Click the Layout pane.
-
Locate the line for which
you want to create a translate statement.
-
Double-click
the Layout icon to display
the PDW Translation Table.
-
In the Search
For Value field, enter the value you want to translate.
The system displays the value in quotation marks.
-
In the Replace
With Value field, enter the translated value.
The system displays the value in quotation marks.
-
Double-click the Formula
icon to display the Formula Builder.
-
Enter
a formula that concatenates designated data provider fields
or appends prefixes or suffixes to designated data provider fields.
-
Save your changes and exit
the window.
-
Display the import
layout or export layout you are defining.
-
Select the item in the Data Identifier column for which
you want to create a translate statement.
-
Use the Layout
hot key to display the PDW Import Map Layout screen.
-
Use the Translate
hot key to display the PDW Translation Table screen.
-
To
create a translate statement that changes values, complete the
following steps:
-
Press Alt+Insert
to insert a blank line in the From
Value column.
-
In the From
Value column, enter the value you want to translate.
The system displays the value in quotation
marks.
The system displays the value in quotation
marks.
-
Repeat the previous steps
for each value you want to translate.
-
In the To
Value column for the **Any Other Data** value, enter the
translated value the system should use for any From
Value other than the ones you have listed.
-
To
create a translate statement that combines multiple data items
or appends prefixes or suffixes to data items, complete the following
steps:
-
Position the cursor in
the To Value column next
to an entry in the From Value
column.
-
Use the Enter
Formula hot key to display the Formula Builder screen.
-
Enter
a formula that concatenates designated data provider fields
or appends prefixes or suffixes to designated data provider fields.
-
Press Esc
to save the formula and return to the PDW Translation Table screen.
-
Use the following hot keys
as needed:
Hot
Key
|
Function
|
Find
|
Positions the cursor
at the Find prompt,
where you can enter a search value for locating an item listed
on the screen.
|
View
All
|
Displays the PDW
Conv/Trans Table screen, which displays all the convert statements
and translate statements defined for...
|
-
Press Esc
to save the statements and exit PDW Translation Table screen.
See Also:
PDW Translate Statements
Tasks Not Available
in Solar