Hi
I am trying to TRIM the Char datatype in Transformer stage.
Process
---------
Output column from teradata isCHAR datatype. At times when lookup fails the column will not be populated(It must be NULL). BUT when I try to check it for NULL or '' , its not working. When i check the length of the column its always 4, though in unix its is NULL.
I tried
TRIM(inputcolumn,'','D') -Not working
Convert() not working.
Any way to Trim the CHAR datatype , so that I can check IsNull function.
Thanks
Trim Char Datatype
Moderators: chulett, rschirm, roy
Trim Char Datatype
Thanks, BK
Re: Trim Char Datatype
Hi
I just used a copy stage between Teradatastage and Lookup stage, input column is CHAR and same column in output is VARCHAR. As I am checking for IsNull() its working fine.
If still there is way of triming in it transformer , please reply.
I just used a copy stage between Teradatastage and Lookup stage, input column is CHAR and same column in output is VARCHAR. As I am checking for IsNull() its working fine.
If still there is way of triming in it transformer , please reply.
Thanks, BK