Adding condition in conditional split

59 Views Asked by At

I am trying to follow the process below to transform data from flat file to DB. I also have an update_dt_tm column in the source. I need to put a condition that if updt_dt_tm is between last 10 mints it updates all the columns in that table.

How can I do that?

enter image description here

I am just trying to add a condition in the conditional split.

Source table : person_id,person_name,address,country,updt_dt,amount

Destination Table : person_id,person_name,person_address,person_country,person_updt_tm,person_amt

1

There are 1 best solutions below

2
On

It was actually a simple thing.

I just needed to go and put this condition

(DT_DBDATE)[Copy of updt_dt] >= (DT_DBDATE)"01/07/2018"