View this page in the latest version of Appian. merge() Function Share Share via LinkedIn Reddit Email Copy Link Print On This Page Function merge( list ) Takes a variable number of lists and merges them into a single list (or a list of lists) that is the size of the largest list provided. Parameters Keyword Type Description list Any Type Array Variable number of lists to merge into one list. Returns Any Type Usage considerations Use this function when you have a looping function referencing a rule or function that takes more than one argument. The order of the argument must match the order of your rule input parameters. Shorter lists are padded with null entries. Examples Merging two lists of the same length 1 2 3 4 merge( {1, 2, 3}, {4, 5, 6} ) Returns {{1, 4}, {2, 5}, {3, 6}}. Creates a list with 3 nested lists. Merging many lists of the same length 1 2 3 4 5 6 merge( {1, 2}, {true, false}, {"a", "b"}, {10,20} ) Returns {{1, true, "a", 10}, {2, false, "b", 20}}. Creates a list with 2 nested lists. Merging two lists of the different lengths 1 2 3 4 merge( {1, 2, 3}, {4, 5} ) Returns {{1, 4}, {2, 5}, {3, null}}. Creates a list with 3 nested lists. Merging a single list 1 2 3 merge( {1, 2} ) Returns {{1}, {2}}. Creates a list with 2 nested lists. Usage in another looping function: filter() Learn more about the filter() function. Here a list is being filtered by the function a!isUserMemberOfGroup and 2 parameters which accept lists need to be passed in the context parameter of filter. 1 2 3 4 5 filter( a!isUserMemberOfGroup, {"user1", "user2", "user3"}, merge({cons!myGroup1, cons!myGroup2}, {true, true}) ) Returns {"user1"} when only user1 is a member of the groups referenced in cons!myGroup1 and cons!myGroup2. The merge function maps the list values to the correct parameters in this example. Learn more about a!isUserMemberOfGroup(). Feature compatibility The table below lists this function's compatibility with various features in Appian. Feature Compatibility Note Portals Compatible Offline Mobile Compatible Sync-Time Custom Record Fields Compatible Can be used to create a custom record field that only evaluates at sync time. Real-Time Custom Record Fields Incompatible Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. Process Reports Incompatible Cannot be used to configure a process report. Process Events Incompatible Cannot be used to configure a process event node, such as a start event or timer event. Feedback Was this page helpful? SHARE FEEDBACK Loading...