Description
Index creation from Transform does not work when coalesce fields exist on the parent table of the transform target table.
Steps to Reproduce
-
Create a new transform map with the following values:
- Name: <Your choice>
- Source table: Any available table
- Target table: Software Catalog [pc_software_cat_item]
-
Add a field mapping with the following values to the transform map:
- Use source script: selected
- Target field: Product ID (Note: Product ID is a field from the table Product Catalog Item [pc_product_cat_item])
- Coalesce: Checked
-
Save the transform entry and transform map.
-
Reload the transform map.
A message indicates that the coalesced fields are not indexed.
-
Follow the prompts to create the index.
Note that the system attempts to create the index on the Software Catalog [pc_software_cat_item] table where the field does not exist and fails.
Workaround
Manually create an index for a coalesce field:
- Identify the actual table that the field belongs to. For example, the field 'product_id' belongs to the parent table pc_product_cat_item instead of the target table pc_software_cat_item.
- Navigate to System Definition > Tables & Columns.
- Select the table and then in the index creator section, select the coalesce field from the Available column and then select Create index.
Related Problem: PRB690388