Making a new Column from two columns with logic.

My goal is to make a new column of data that is the combination of two other columns. This needs to happen after some joins that happen in order to get the correct information. The new column she be have the data of column 1 if it exists and column 2 if it doesn’t exist.

Please help <3

Hi John,

In this case, you can make use of the calculated element transform. You can create a new column based on any formula/calculations that rely on any existing columns.
In your case, you will simply need a check to if data in column 1 empty or null for every row and for the rows this case is true you can the can then use the data from column 2.

1 Like