Create a column by selecting a data point from multiple columns from ETL or beastmode
I am trying to create a new column from multiple columns in my dataset to extract the data point that I need. Let's just say that there are three columns:A,B, and C that I am looking at to see which data point I need to use.I want all the data I use to be in the newly created column Z. If there is a name in column A, but nothing in B and C, then I want to extract data from column A and put it in column Z. If there is a name in column B, then I want to extract a name in column B, instead of A. The same with column C. C takes priority over B, B takes priority over A.
Is it possible to do this in ETL? or beast mode?
Thank you so much