Skip to content

    • Magic ETL

    Magic ETL

    Can I move a variable to one column from another?

    Member
    in Magic ETL

    I want my Credit Type 1 to have just Position Owner or none, and Credit Type 2 to have Candidate Owner or none.

    Can this be done? I was trying the below SQL statement, but it is not working.

    SET Credit Type 2 = Credit Type 1WHERE Credit Type 1= 'Candidate Owner' AND Credit Type 2='none"

    I am just learning SQL, so still not sure of the possibilities.

    image.png

    I originally split the below column, but it didn't give me the results needed. Almost!

    image.png

    Best Answer

    • Contributor
      Answer ✓

      Hello @kim_barragan0126,

      If I understood correctly, this is your initial column, right?

      image.png

      Either way, sure you can do it in various methods using CASE logic in Magic ETL. Here is one that I did for you with a Formula tile:

      image.png

      Here are the results:

      image.png

      If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

    Answers

    • Contributor
      Answer ✓

      Hello @kim_barragan0126,

      If I understood correctly, this is your initial column, right?

      image.png

      Either way, sure you can do it in various methods using CASE logic in Magic ETL. Here is one that I did for you with a Formula tile:

      image.png

      Here are the results:

      image.png

      If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

    • Member

      Thank you very much! Perfect!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories