User16764241763
Databricks Employee
Databricks Employee

@Jack Homareau​  Can you try union functionality with dataframes?

https://sparkbyexamples.com/pyspark/pyspark-union-and-unionall/

and then try to fill NaNs with the desired values?