How to get unique items from an array of collections

Tommyst · July 22, 2024, 2:28pm

How can I split an collection into two collections? Quite stuck on this one how to do it smart.
You can do a Split but maybe there is a quicker method.

I have multiple names in one row and I want to split them as I can than do a Distinct on it (otherwise it does not work, as it will see the two names as unique).

This is an example:

[
    {
        "__IMTKEY__": "Project",
        "array": [
            {
                "ACL": "Julia"
            },
            {
                "ACL": "Julia, Mike"
            },
            {
                "ACL": "Roos"
        ]
    }
]

Thank you!

samliew · July 22, 2024, 2:51pm

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of one module:

{{deduplicate(split(join(map(1.array; "ACL"); ","); ","))}}

Output

Screenshot_2024-07-22_220722

Give it a go and let us know if you have any issues!

For more information on these functions, please refer to the Help Center.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

Help Center | Tutorials
Make Academy – learn Make and get your certificate
Discord Server – join us in live chat for fans of Make!

Help Center Basics

Mapping – What is mapping? What can I map?
Mapping with arrays – How to map items in an array
Aggregate an array for mapping complex fields
Tokens for parseDate | Tokens for formatDate
HTTP modules – Make a request, Get (download) a file
Webhooks – Error Handling, Responding to webhooks

Articles & Videos

Router Magic Formula - YouTube
Error Handlers in Make - YouTube playlist
Getting started with OpenAI
How to use Regex in Make

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

samliew · July 22, 2024, 2:51pm

Module Export

You can copy and paste this module export into your scenario. This will paste the modules shown in my screenshots above.

Copy the JSON code below by clicking the copy button when you mouseover the top-right of the code block
Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the canvas.
Click on each imported module and save it for validation. You may be prompted to remap some variables and connections.

Click to Expand Module Export Code

JSON - Copy and Paste this directly in the scenario editor

{
    "subflows": [
        {
            "flow": [
                {
                    "id": 30,
                    "module": "util:SetVariable2",
                    "version": 1,
                    "parameters": {},
                    "mapper": {
                        "name": "ACL",
                        "scope": "roundtrip",
                        "value": "{{deduplicate(split(join(map(29.array; \"ACL\"); \",\"); \",\"))}}"
                    },
                    "metadata": {
                        "designer": {
                            "x": 241,
                            "y": -716
                        },
                        "restore": {
                            "expect": {
                                "scope": {
                                    "label": "One cycle"
                                }
                            }
                        },
                        "expect": [
                            {
                                "name": "name",
                                "type": "text",
                                "label": "Variable name",
                                "required": true
                            },
                            {
                                "name": "scope",
                                "type": "select",
                                "label": "Variable lifetime",
                                "required": true,
                                "validate": {
                                    "enum": [
                                        "roundtrip",
                                        "execution"
                                    ]
                                }
                            },
                            {
                                "name": "value",
                                "type": "any",
                                "label": "Variable value"
                            }
                        ],
                        "interface": [
                            {
                                "name": "ACL",
                                "label": "ACL",
                                "type": "any"
                            }
                        ]
                    }
                }
            ]
        }
    ],
    "metadata": {
        "version": 1
    }
}