Can I move a variable to one column from another?

kim_barragan0126
kim_barragan0126 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

  • Manasi_Panov
    Manasi_Panov 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

  • Manasi_Panov
    Manasi_Panov 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.

  • kim_barragan0126
    kim_barragan0126 Member

    Thank you very much! Perfect!

Categories