Storing unique entries into a data store | Community
Skip to main content
Level 9
February 14, 2025
Solved

Storing unique entries into a data store

  • February 14, 2025
  • 2 replies
  • 598 views

Hi Fusion Community,

 

I have an iterator module that iterators through a project's hours (many hour entries, some of which have the same hour owner ID). My iterator's output shows a number of bundles. I need a way to store or generate a list of a deduplicated owner ID's when comparing all of the bundles from the iterator output. Here's a screenshot of the iterator's output.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Does anyone know how to do this?

Thanks,

Nick

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ChrisStephens

Since it looks like you're feeding that array into an iterator, you can make your owner ID list without the iterator with this function in a variable.

 

deduplicate(map({your source array};ownerID))

2 replies

lgaertner
Level 9
February 18, 2025

Hello Nick,

 

without having tried, I would think about this approach:

 

1. Use an Array aggregator to aggregate your bundles into an array

2. Use the Set variable module with the array function deduplicate() to get an unique array

3. Store the values into the data store

 

 

Regards

Lars

NickVa7Author
Level 9
February 18, 2025

This will work too, thanks, Lars!
Decided to go with Chris' option since I can cut out the data store.

ChrisStephens
Community Advisor
ChrisStephensCommunity AdvisorAccepted solution
Community Advisor
February 18, 2025

Since it looks like you're feeding that array into an iterator, you can make your owner ID list without the iterator with this function in a variable.

 

deduplicate(map({your source array};ownerID))

NickVa7Author
Level 9
February 18, 2025

Perfect!!  This is what I needed.  Thanks, @chrisstephens