My source table has a varchar column where the data is entered as numerics (14.2, 13 30 etc) and also as alphabets (TBD, N/A etc.). In my iDM data flow in the target transformation I would like to populate the target column if my source has only numerics and default other incoming values to zero.
In iDM is there any function which does this for me? I was expecting a boolean function like isNumber() which takes a string as input and returns true or false.
Windows 2008 Server
Functions CHKFMT and PATTERN can be used to check a character string for numerics and alphas.
|Powered by Social Strata|