@adrin it may not be a parameter to select and not in one sql statement, but it is possible without having to copy and paste:df1 = spark.createDataFrame([(None, None), (1, None), (None, 2)], ("a", "b"))
display(df1)df1.createOrReplaceTempView('table...
