I don't understand exactly your request, if you are looking for something related to upsert check this thread
For dealing with NULL values I recommend :
- Use the “if” and “else” conditions in subsequent activities to check for null values in the output of the previous activity. If a null value is encountered, you can choose to skip the activity or provide a default value.
- Use the coalesce function to replace any null values with a default value. The coalesce function returns the first non-null value in a list of expressions, allowing you to provide a default value if the original value is null.
- Use the null function to test for null values in the activity output. The null function returns a Boolean value indicating whether the specified expression is null, allowing you to branch the pipeline based on whether the output is null or not.