The retain columns filter enables you to specify the columns that you would like to keep.
For example, your sales team wants a table with all of your users' names and phone numbers. You can import a data set of user registrations from your website, but that data set has names, phone numbers and 50 other columns that you don’t need. The retain filter allows you to specify that only the name and phone number columns are ingested.
To apply the retain columns filter:
Select Retain Columns.
Select Add Filter.
The Retain Columns dialog opens.
Edit the parameters.
Optionally, do one of the following: