Substr issue
Posted: Mon Nov 21, 2011 10:49 pm
Hi all,
My input column contains year,month and week value like 2011014. Where first 4 characters correspond to the year and second 2 characters correspond to month and the seventh character correspond to the week.
In transformer, am using function like this to extract month value.
year_month_week_id[5,2] and am getting value as 1. But i want the value to be 01. I changed the scale in the transformer to be 2. But still the same issue.
Anyone please throw some light on this.
Thanks in advance,
My input column contains year,month and week value like 2011014. Where first 4 characters correspond to the year and second 2 characters correspond to month and the seventh character correspond to the week.
In transformer, am using function like this to extract month value.
year_month_week_id[5,2] and am getting value as 1. But i want the value to be 01. I changed the scale in the transformer to be 2. But still the same issue.
Anyone please throw some light on this.
Thanks in advance,