2 Replies Latest reply on Dec 3, 2020 4:20 AM by JanLeendert Wijkhuijs

    How to parametrise expression transformation columns

    Aman Gupta New Member

      Hi Folks,


      I have a requirement where i do want to parametrise the expression transformation columns with day-15 and day-1 date.


      For Ex:-


      Expression Transformation

      ColumnName               Value

      StartDate                       Day-15 i.e 11-17-2020

      EndDate                        Day-1 i.e 12-01-2020


      Values for mentioned columns , I want from parameter file which it will call at runtime. The problem I was facing is of type conversion. I passes parameters like below in the parameter file:-


      $$Start_Date=date +%m/%d/%Y -d '15 days ago'

      $$End_Date=date +%m/%d/%Y -d '1 days ago'


      But while running it takes passed value as string.


      Please suggest , how it can be done.