Welcome to Catalog Tips

Search more than 200 articles to learn more about creating and automating your product catalogs

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

GROUPLIST – Convert field values into list

Overview

This Custom Field takes values from the nominated field and creates a delimited list. The list can be separated by optional parameters for first, regular and last occurrence. The default parameter is a comma.

Syntax

GROUPLIST(‘GroupPath‘, ‘SortField‘, ‘SourceField‘, ‘FirstSeparator‘, ‘RegularSeparator‘, ‘LastSeparator‘, ‘AddAll‘, ‘AddEmpty‘)

GROUPLIST(‘Parent Category:Child Category‘,’Price‘,’‘,’,’, ‘‘)

Element Description
GroupPath Group path, delimited by colons
SortField The field to sort the records in the group by. Preface the field name with < or > to specify ascending or descending.
SourceField The field to retrieve the values from.
FirstSeparator The separator to use between the first and second value in the delimited list (optional).
RegularSeparator The separator to use in the delimited list after the second value in list (optional).
LastSeparator The separator to use in the delimited list between the second-last and last value in list (optional).
AddAll Add TRUE to include duplicate values within the list (optional). Without this, only distinct values will be shown.
AddEmpty Add TRUE to include empty values within the list (optional). Without this, only non-empty values will be shown.

Examples

GROUPLIST(‘Parent Category:Child Category‘,’Price‘, ‘Price‘, ‘, ‘, ‘, ‘, ‘and ‘)
In this example, the field will be populated with a comma delimited list of all Price fields in each ‘Child Category’ group, sorted by ‘Price’, with ‘and ‘ replacing the comma between the second-last and last value on the list.

Price GROUPLIST
12.00 12.00, 16.00 and 20.00
16.00 12.00, 16.00 and 20.00
20.00 12.00, 16.00 and 20.00

GROUPLIST(‘Parent Category:Child Category‘,’Price‘, ‘Colour‘, ‘,followed by ‘, ‘, ‘, ‘and ‘)
In this example, the field will be populated with a comma delimited list of all Price fields in each ‘Child Category’ group, sorted by ‘Price’, with ‘and ‘ replacing the comma between the second-last and last value on the list.

Price Colour GROUPLIST
12.00 Red Red, followed by Green, Yellow, Blue and Yellow
16.00 Green Red, followed by Green, Yellow, Blue and Yellow
20.00 Yellow Red, followed by Green, Yellow, Blue and Yellow
24.00 Blue Red, followed by Green, Yellow, Blue and Yellow
27.50 Yellow Red, followed by Green, Yellow, Blue and Yellow

See also

DISTINCTLIST

Table of Contents