Home Forums Power Update PQ: 3 conditions, 2 from another column, then 1 possible replacement of 1st

This topic contains 0 replies, has 1 voice, and was last updated by  HubbaBuba 1 week, 3 days ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #18034

    HubbaBuba
    Participant
    • Started: 1
    • Replies: 0
    • Total: 1

    Conditional change for separate column IF the 1st digit of a string contains “X###”, then change to “Y###”

    If DC = A and DS = 2XXX replace the 2 with a 3
    If DC = B and DS = 5XXX replace the 5 with a 6
    Dependant Column (“DC”) / Data string (“DS”) / Should transform to
        A                                                2888                                      3888
    B                                                3888                                      3888
    A                                                8888                                      8888
        B                                                5888                                      6888
    A                                                2888                                      3888
    B 2888 2888

    3 conditions, 2 from another column(DC), then 1 possible replacement of the 1st digit (from DS)

    I need to transform this in PowerQuery please – THANK YOU!

    Attachments:
    You must be logged in to view attached files.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.