Need a logic for Implementing Months

dr.murthy · Post by **dr.murthy** » Tue Jan 25, 2011 4:16 am

HI ,

I have a funny requirement like , i have a source filed it contains distinct integer values 1 to 12 , my requirement is if its
1 - janauary
2 - febrauary
3 - march ....

Is there any way other than writing a Stage variables .

nayanpatra · Post by **nayanpatra** » Tue Jan 25, 2011 5:40 am

You can create a file having all the months(month number, month name) and lookup into it with the month number to fetch the corresponding month name.

dr.murthy · Post by **dr.murthy** » Tue Jan 25, 2011 5:56 am

Thanks for responding ....

Is there any data stage built in function to handle this ???

nayanpatra · Post by **nayanpatra** » Tue Jan 25, 2011 6:29 am

I am not aware of any... Are you facing any problem in implementing the lookup file???

sajidkp · Post by **sajidkp** » Tue Jan 25, 2011 6:31 am

HI,

More easily, You can write an if else statement is tranformer to get this.

Example:

If value=1 then 'January' else
if value=2 then 'February else
if .................
--------------
-----------------
else 'December'

dr.murthy · Post by **dr.murthy** » Tue Jan 25, 2011 7:30 am

No , Am not facing any problem but requirement saying Don't use if then else and lookup file or data stage routine ...

chulett · Post by **chulett** » Tue Jan 25, 2011 7:36 am

Construct an otherwise static date from your month number, then StringToDate() followed by DateToString() using just %mmmm for the format mask.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 25, 2011 2:45 pm

Use a Modify stage and lookup_string_from_int16() function.

or

Use a Lookup stage sourced from a file containing the mappings (or even from an External Source stage containing 12 echo commands).