I have been working with and successfully used the Transform and Cleanse module to Group columns based on the value of the column being used but am stuck on a case where the condition of two columns is used.
“Forc_Period_End_Dt” and “Cust_Coeff_On” are the names of the columns where the value is being evaluated and I want to create a column called “Algorithm”.
I am trying to run a query off an SQL database in Toad Data Point.
If the Forc_Period_End_Dt > 0 and the Cust_Coeff_On = Y then show “Enhanced - CC” in the Algorithm column
If Forc_Period_End_Dt > 0 and Cust_Coeff_On <> Y then show “Enhanced - OpCo” in the Algorithm column
Else show “Linear” in the Algorithm column.
Using the T&C module is my preference for this case but, if this cannot be done in that module, would someone please assist me in adding it to the Select statement?
Thank you in advance for any feedback/assistance.