Create Buckets

The Create Buckets transformer allows you bucketize categorical columns into separate groups . for example if there is a column named country and has rows karnataka,telangana,maharashtra, Bihar., you will be able to create a buckets grouping Karnataka and telangana as South India and Maharashtra and Bihar as North India.

Create Buckets Transform dialog is shown as below:

1. Enter Title like most of the other transforms. Ensure that the Title is uniquely identifying the step
2. Enter Description to provide further information for this particular step. This is helpful in ensuring the transform step is readable in a complex workflow, ensuring readability. This step however, is Optional.
3. New Column Name Should be given for the new column to be created.
4. Select Column you want to bucketize .
5. After selecting the column you want to bucketize you will see an option called Add Grouping Items. Click on it to Create to see the next the section.

6. Fill the Group Name you want to create Inside the Group Name dialog box
7. Select all the values you want to put under your Group Inside Select Unique Values
8. Click on Create when you finish filling the step.

The filled step would look like the one below: