DW_PRODUCT_FAMILY_ID as %PRODUCT_KEY,
MARKET_NAME AS [Market],
DISPLAY_PRODUCT_GROUP_NAME AS Product,
applymap('ProdColorPrimary',DW_PRODUCT_FAMILY_ID,RGB(128,128,128)) as PrimaryColor,
applymap('ProdColorSecondary',DW_PRODUCT_FAMILY_ID,RGB(0,128,255)) as SecondaryColor
You can not use the new field name in same load statement, so use the original field name.