Alias for values in Column

[#1]

Hi All,

I have a requirement like i want to do alias for values in a particular Column and my source is Excel sheet

say for example

Column Name is Key Individual and the values are Hospital-KI and IDN -KI . Now i want to do alias these values like H-KI and I-KI in this Column at Script level.

How to achieve this

Thanks in Advance

Reddi Kishor

Happy Viewing

[marcus_sommer]

Try: left([Key Individual], 1) & '-' & subfield([Key Individual], '-', 2)

- Marcus