How to derived expression in derived column

Question

Hi,

If percode in ('crp','crdist','acc')and seq_numb is null then
If transaction_ty =0 then 'crrcpt'
If transaction_ty =9 then 'crsst'
please help me.how to Derived this query

Thanks...
Mani

Answer 1

Hi @patan imran ,

Welcome to Microsoft Q&A!

Please refer to below steps:

transaction_ty == 0 ? "crrcpt" : "crsst"  

For more information, please refer to below links:

? : (Conditional) (SSIS Expression)
Nested Conditional Operators in an SSIS Derived Column

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.