SYMPTOM:
Column aliases do not reflect the new column name when the expression is defiend with a RTrim or LTrim function in Strategy Developer 9.x.
STEPS TO REPRODUCE:
Execute the following in Strategy Tutorial:




CAUSE:
This is a known limitation of Strategy Developer 9.x. When the expression is defined with the column name without any function, the column alias gets updated with the new column name.
ACTION:
Edit the column alias and specify the name as need be. For more information about options for column aliases, refer to the following Technical Note:
KB4371 - How to select or modify the column data type for an attribute or fact in Strategy Architect 9.x and 10.x