Is there a way to ignore a value I don’t want loaded?

Q: We have N/A values in some of our data. What’s the best way to keep those values from loading?

A: You can create a user defined column using the “Replace” built in function. For the newValue, enter “NOTHING” (without the quotes). Another option is to create SQL (or a table filter) to exclude the rows with missing data using a WHERE clause.