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

DISTINCTLIST – Create unique list of values

Overview

This Custom Field creates a list of unique values based on a set of parameters.

Syntax

DISTINCTLIST(‘,‘, FIELDSTR(Field A), FIELDSTR(Field B))

 

Element Description
Separator The delimiter separating the values
FIELDSTR(Field A) String contents

Example

1. For the table

Shape
Round
Round
Square

DISTINCTLIST(‘,‘, FIELDSTR(Shape A), FIELDSTR(Shape B), FIELDSTR(Shape C))

will return

Round, Square

2. For the table

Shape
Round
Triangular
Square
Triangular
Round

DISTINCTLIST(‘;‘, FIELDSTR(Shape A), FIELDSTR(Shape B), FIELDSTR(Shape C), FIELDSTR(Shape D),FIELDSTR(Shape E))

will return

Round; Triangular; Square

See also

FIELDSTR

Table of Contents