Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try: left([Key Individual], 1) & '-' & subfield([Key Individual], '-', 2)
- Marcus