Hello,
I'm trying to use LUA to take a substring of my column value and mask it using the Affinity provider, but I must be missing how to pass the value of the substring to the call.
Example:
Source Value = ABCD12345999
I want to perform a substring function to get the value "12345" from the source value. I accomplish that by doing:
myString = string.sub("ABCD12345999", 5, 9)
Result:
myString = 12345
Next:
How do I construct the Affinity call to use "myString" as the source?
Thank you,
Trong
------------------------------
Trong Bo
Senior Environment Administrator
HealthNow New York
------------------------------
#InfoSphereOptim#Optim