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.

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.

To create a translate statement:

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.

In the To Value column, enter the translated value.

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.