In this session the team reviews the building out of a Query and finalizes the Lead query populating data in a data extension. Later on in the session the team utilizes the Query Studio app and makes some on the fly code updates to handle null values in the data.
Build Components
| Asset | Notes/tips |
| Data Extension | Be mindful of selecting nullable and the impact it will have on the build |
| Query Studio | How to use Query Studio to validate the data set and quickly make code updates to refine the query logic |
| Query Functions | How to use IS NOT NULL to remove NULL records in your query logic |
handsonsfmc.com 
Leave a comment