Hey everyone,
I'm using data that basically needs an (=if) statement like we were going to be using excel--
We have two columns called current income and qualified income. The 'income' column needs to populate with 'current income' if another column, called 'instrument' reads 'first home' otherwise, we need to use qualified income to populate the new column called 'income'.
Is the best way to do this using a beast mode? or what tile would i use in magic ETL? im lost as to how i would do either of them as well. Any and all info would be greatly appreciated.