Sort Column
Description
This activity sorts the values of columns based on the priority of selected columns. It allows multiple columns and corresponding sort orders to be provided as inputs.
Input
Data Only
Output
Transformed Data
Configuration Fields
- Column Map
Specifies the columns to sort, their corresponding sort orders, and the transformations to apply.- Column Name of the column to sort.
- Sort Order Sort order to apply (e.g., Ascending or Descending).
Sample Input
product_id | rating | discount_percentage | price |
---|---|---|---|
B07JW9H4J1 | 4.2 | 64% | ₹399 |
B07AB2CD34 | 4.5 | 50% | ₹1,499 |
B07XY1MN67 | 4.5 | 70% | ₹999 |
B07EF3PL88 | 3.9 | 55% | ₹799 |
Sample Configuration
Sample Output Data (Sorted by Configuration)
product_id | rating | discount_percentage | price |
---|---|---|---|
B07XY1MN67 | 4.5 | 70% | ₹999 |
B07AB2CD34 | 4.5 | 50% | ₹1,499 |
B07JW9H4J1 | 4.2 | 64% | ₹399 |
B07EF3PL88 | 3.9 | 55% | ₹799 |