Sort your data within an attribute
Sort your data within an attribute in Data View in Productsup.
Introduction
If some of your attributes in Data View contain item lists, you can sort them in a necessary order with the help of special rule boxes.
Sort values in a descending or ascending order
The Sort Values rule box lets you sort a list of items in your attributes in ascending or descending order.
Go to Data View from the site's main menu.
Choose the Intermediate stage or the desired export channel from the drop-down menu in the upper ribbon.
Select the Edit button in the attribute column you want to sort. The toolbar opens on the right-hand side.
Select the Add Box drop-down menu in the opened toolbar.
Search for and select the Sort Values rule box.
Define the delimiter to separate the list items.
Select descending or ascending from the Order drop-down menu.
Select Save to apply the rule box.
Here's an example of applying the Sort Values rule box:
Before | After |
|---|---|
white, red, blue, yellow, green, black | black, blue, green, red, white, yellow |
Sort values in a custom order
The Sort Values in Cell rule box lets you sort an item list in a custom order. You can sort values according to the specified order or regex patterns.
Go to Data View from the site's main menu.
Choose the Intermediate stage or the desired export channel from the drop-down menu in the upper ribbon.
Select the Edit button in the attribute column you want to sort. The toolbar opens on the right-hand side.
Select the Add Box drop-down menu.
Search for and select the Sort Values in Cell rule box.
Define the delimiter to separate the items in your attribute.
Select descending or ascending from the Order drop-down menu.
Note
The platform ignores the order selected from the Order drop-down menu if you list items in the Sort field.
Define whether the listed values are strings or regex in the Mode drop-down menu.
Note
A regular expression (regex) is a sequence of characters that uses specific syntax or structure rules to define a search pattern and lets you search your data for a particular pattern of text instead of the exact text.
Remember to place the search pattern within two forward slashes (
/) or hash symbols (#). For example,/regex/or#regex#.Optionally, list values in the desired sorting order in the Sort field. Enter one value per line only.
Note
All not-listed values appear in the order by their first appearance in the list after the listed values.
Select Save to apply the rule box.
Here's an example of applying the Sort Values in Cell rule box with the regex mode and a custom list of values:
Before | After |
|---|---|
|
|