I have an excel file that I load into snowflake. I would like use column1 in excel to map to column1 in snowflake but if excel column1 is null then use column2.
I can’t find examples of what you can do in the expressions. Can I just do an NVL(column1,column2) in the expression field?
yes, you can do something like nvl() on the custom expressions in the Schema tab. Note - you’ll want to create a new field for this, such as the below:
hope that helps!
Taylor