Add the date parameter in column derivation in transformer

rajeevm · Post by **rajeevm** » Wed Apr 25, 2012 8:02 am

Hi All,

I need to add the date parameter in the column derviation in the transformer stage which the field should be hardcoded with the date paramter . For example List_Id -- " 01_yyyymmdd" I defined the date paramter as todays date in the job paramter I am passing that value in the transformer stage but its giving the same output as "01_#TODAYS_DATE#" instead of giving "01_20120425"

I appreicate your responses.

Thanks in advance

rajeev

chrisjones · Post by **chrisjones** » Wed Apr 25, 2012 8:13 am

try this..

'01':TODAYS_DATE

chrisjones · Post by **chrisjones** » Wed Apr 25, 2012 8:14 am

small correction...

'01_':TODAYS_DATE

rajeevm · Post by **rajeevm** » Wed Apr 25, 2012 8:31 am

Thanks Chris It worked . I appreciate your quick response.

Regards,
raj