Creating PDW Convert Statements

Use convert statements to change the values of incoming or outgoing data elements in the Product Data Warehouse (PDW). The system converts the data values before importing them into the PDW or exporting them from the PDW.

Translate and convert statements differ, as follows:

Translate statements affect entire fields of data. Translate statements are commonly used on discount class, unit of measure, and UCC number data.
Convert statements apply to single words within fields. Convert statements are commonly used on product descriptions.

For example:

A vendor provides the following description:

KOH 2524L GRN OV TOILET SEAT

You want to convert the description to:

KOHLER 2524L GREEN OVAL TOILET SEAT

To create PDW convert statements:

Display an import layout on the PDW Import Maintenance screen or an export map on the PDW Data Export Maintenance screen.
Select the metadata item for which you want to create a convert statement and use the Convert hot key to display the PDW Conversion Table screen.
In the Search For Value column, enter the value you want to convert.
In the Replace With Value column, enter the converted value.

The following table simulates the entries for the Kohler example from the overview:

Search For Value	Replace With Value
KOH	KOHLER
GRN	GREEN
OV	OVAL

Use the following hot keys as needed:

The system converts the description as shown above.

Option	Function
Enter Formula	Displays the Formula Builder screen, where you can enter a formula for creating the converted value.
Find	Moves the cursor to the Find prompt, where you can enter text and locate the line item in the table containing that text.
View All	Displays all the convert and translate statements for the selected data identifier on the PDW Conv/Trans Table screen.

Save the statements and exit the PDW Conversion Table.