Post reply

Replace multiple Values in Derived coulmn expresion

  • June 25, 2012 at 2:39 pm

    #392600

    Hi !

    I would like to Swap the values in a column called Store ID using the derived Coulmn in SSIS

    Below is my expression and could some one guide me here .. Thanks in Advance

    (StoreID==4)? 10: StoreID || (StoreID==10)?4 :StoreID

  • June 25, 2012 at 11:34 pm

    #1505388

    Try this:

    (StoreID == 4) ? 10 : ((StoreID == 10) ? 4 :StoreID)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 26, 2012 at 2:33 pm

    #1505845

    Thank you very much ... that worked for me 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply