I have columns with Created_TS, FT_FLAG (1,0) AMT TRAN_KEY FT_DT CUSTOMER_NAME Created_TS FT_FLAG AMT TRAN_KEY FT_DT CUSTOMER_NAME 1JAN1960:00:00:00 1 40000 1234 10JAN2019 Oracle 1JAN1960:00:00:00 1 40000 12345 10JAN2019 Oracle 1JAN1960:00:00:00 0 500000 123456 10JAN2019 Java 1JAN1960:00:00:00 0 40000 12334567 10JAN2019 Java 1JAN1960:00:00:00 1 20000 123455678 10JAN2019 SUN 1JAN1960:00:00:00 0 30000 123456789 10JAN2019 JAVA The above data set is an example of mine, i need to create a flag stating if FT=1 and Amount = 40000 then Y, FT = 0 and Amount = 500000 then N end as Sent_flag for Same Customer with transactions
... View more