How to Create Another Column Based on Nulls

[jsamstad]

Hello! 

How do I create another column (CLASS_ID) that is either the value 203 or 205 depending on if the SKU column is null. I'd like for this pattern to repeat throughout the table. So, the second, third, and sixth row of CLASS ID should be 203, 205, 203 with the other rows being null. Thanks in advance!

SKU

123

null

null

234

345

null

[gautiergodard · Accepted solution]

@jsamstad here is one way of doing it !

Let me know if it works.

Hope this helps.

[jsamstad · Accepted solution]

🕺🕺🕺🕺Yes! The Append tool and Formula tool did the trick. Thanks 👊