Forum Discussion

ddellsperger's avatar
ddellsperger
Admin
3 years ago

Advent of Code via SnapLogic IIP

I’ve been a pretty big fan of Advent of Code since I found out about it in 2019 and when I started with SnapLogic in 2021, I figured it could be pretty cool to try to use the SnapLogic IIP to solve a...
akarsh's avatar
akarsh
New Contributor III
2 years ago
Copy LinkReport

Sorry I posted the question in wrong thread.

input will be like this

{
"totalCount": 4,
"dataList": [
{
"IfaNumber": "1",
"alink": "",
"agroupId": ""
},
{
"IfaNumber": "2",
"alink": "",
"agroupId": ""
},
{
"IfaNumber": "3",
"alink": "",
"agroupId": ""
},
{
"alink": "",
"agroupId": ""
}
]
}


Output
["1","2",3"] 


this question


https://community.snaplogic.com/t5/designing-and-running-pipelines/filter-single-attribute-from-json-list-to-use-it-in-a-like-query/m-p/24940#M14723

Aleksandar_A's avatar
Aleksandar_A
Contributor III
2 years ago
Copy LinkReport

You can try with the following expression:

$dataList.map(x => x.get('IfaNumber',null)).filter((x,ind,arr) => x != null && arr.indexOf(x) == ind)

Let me know if this helps.

Regards,

Aleksandar.

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    2 years ago
    Copy LinkReport

    No worries! Glad to be of help, that's what this community is all about! 🙂

  • akarsh's avatar
    akarsh
    New Contributor III
    2 years ago
    Copy LinkReport

    Thank you , Thank you. I really appreciate your help. I know I ate your head a lot. Thanks once again 🙂