Remove Fields eliminates unnecessary columns/fields from your data to reduce clutter, improve performance, and focus on relevant information. Choose specific fields to remove or keep only the fields you need.

When to Use It

  • Clean up datasets with too many unnecessary columns
  • Remove sensitive data before sharing reports
  • Prepare data for systems with field limitations
  • Reduce data size for better performance
  • Focus on specific metrics for analysis

Inputs

FieldTypeRequiredDescription
DataDataYesThe dataset containing fields you want to remove
Removal ModeSelectYesChoose “Remove Specific Fields” or “Keep Only Specific Fields”
Fields to RemoveListYes*Names of fields to remove (*For Remove mode only)
Fields to KeepListYes*Names of fields to keep (*For Keep mode only)

Outputs

OutputDescription
Filtered DataDataset with specified fields removed

Credit Cost

Free to use - no credits required.

How It Works

Remove Specific Fields Mode: Removes only the fields you specify, keeps everything else. Keep Only Specific Fields Mode: Keeps only the fields you specify, removes everything else. Example: Original Data:
campaign_namecampaign_idcostimpressions
Summer Sale12345$1505,000
Black Friday67890$3008,500
After Removing “campaign_id”:
campaign_namecostimpressions
Summer Sale$1505,000
Black Friday$3008,500

Choosing the Right Mode

Use “Remove Specific Fields” when:
  • You have mostly useful data with a few unwanted fields
  • You want to remove sensitive or technical fields
  • Most of your columns should stay in the final dataset
Use “Keep Only Specific Fields” when:
  • You have lots of data but only need a few specific fields
  • You want to create a focused, minimal dataset
  • You’re dealing with very wide datasets with many unnecessary columns

Tips

Field Identification:
  • Run a small test first to see what fields are available
  • Check field names carefully - they’re case-sensitive
  • Use data preview to understand your dataset structure
Mode Selection:
  • If you need most fields, use “Remove Specific Fields”
  • If you need only a few fields, use “Keep Only Specific Fields”
  • Keep mode is often faster for very wide datasets
Data Quality:
  • Remove fields with mostly empty or null values
  • Eliminate duplicate or redundant information
  • Keep fields that provide unique, valuable insights

FAQ