Select

The Select operation allows you to specify which fields to include in or exclude from your entities. This operation gives you fine-grained control over the columns that appear in your output dataset.

Overview

The Select operation enables you to:

• Choose specific fields to include in each entity
• Exclude specific fields from each entity
• Apply different field selections to different entity types
• Control the exact data structure of your output

Configuration

Entity-Level Field Selection

The Select operation is configured at the entity level, allowing you to specify different field inclusions for each entity in your dataset:

1. Select which entities you want to apply field filtering to
2. For each entity, choose which fields to include or exclude
3. The operation affects only the entities you configure

Field Selection Options

For each entity, you can:

• View all available fields in that entity
• Select specific fields to include in your output
• All non-selected fields will be excluded from the output

Examples

Select Specific Fields

To include only specific fields in your customer entity:

1. Add the Select operation to your rule
2. Choose the customer entity
3. Select fields like:
   • customer_id
   • first_name
   • last_name
   • email
4. All other fields in the customer entity will be excluded

Select Fields for Multiple Entities

To customize fields for both customers and orders:

1. Add the Select operation to your rule
2. For the customer entity, select:
   • customer_id
   • first_name
   • last_name
   • email
3. For the order entity, select:
   • order_id
   • customer_id
   • order_date
   • total_amount
4. Each entity will only include the fields you specified

This operation is useful when you want to reduce the size of your dataset by eliminating unnecessary fields or when you need to ensure your output contains only specific columns for compliance or integration purposes.