Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.5   8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2    Statistic  


Creates the cross product from two lists.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
List 6.1 Yes Yes Yes Yes Yes
MBS( "List.CrossProduct"; List1; List2 { ; Prefix; Midfix; Postfix; Flags } )   More


Parameter Description Example value
List1 The first list to process. "Hello¶World"
List2 The second list to process. "1¶2"
Prefix Optional
The prefix to use
Midfix Optional
The middle to use.
This text is put between texts from both lists.
Postfix Optional
The postfix to use
Flags Optional
Pass 1 to have no extra newline character on the end of the returned list. Default is 0 to include one to easily concat lists.
Add 2 for a diagonal cross, so we combine each element of first list with the same element index from the second list.


Returns list or error.


Creates the cross product from two lists.
Optionally adds prefix, postfix and midfix.
Returns empty list if one of the lists are empty!


Test with all parameters:

MBS( "List.CrossProduct"; "Hello¶World"; "1¶2"; "before"; "middle"; "after" )

Combine elements from lists:

MBS( "List.CrossProduct"; "Hello¶World"; "1¶2"; "before"; "middle"; "after"; 2 )

See also

Blog Entries

Created 4th March 2016, last changed 17th March 2016

List.CountValues   -   List.DeCombine

Feedback: Report problem or ask question.

MBS FileMaker Plugins