Can I move a variable to one column from another?

kim_barragan0126 · 2024-10-22T22:49:34+00:00

There was an error rendering this rich post.

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.

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

Find more posts tagged with

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

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:

Here are the results:

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

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:

Here are the results:

Thank you very much! Perfect!