This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

It would still be handy to know how to de-dupe arrays of objects. I tried the following but apparently SS2.1 doesn't have findIndex

if you really wanted to do it on an object, you probably want the related `uniqBy`

How would I do it in native javascript? I'd rather not need to get an unfamiliar external library working in NetSuite since this project is due today. &gt;.&lt;

it has a whole family which has taken over the _ global

I know it's well known, but I don't have time to learn it today. :smile:

I'm aware it's much beloved by the people who use it, and I do plan to get around to it some day, just not today. :slightly_smiling_face:

basics is to make a new array and an object (sets, array, or objects depending on your performance needs) to keep track of elements you have seen before

add elements to your new array and then put it into your seen tracker

dont add an element to your new array if its in your seen tracker

for your code, you really want to be careful about using stringify so many times, its not a cheap operation

yeah that was just an example off the interwebs

I guess I could just crawl through the whole array of objects one property at a time

its more that its more efficient to call json.stringify once on each element on the array

rather than stringifying each element every time you do a comparison

its one of those things that leads to poor scaling as array length increases (O(N^2))

Ugh, I'm so confused by the Analytics engine. It makes no sense...

In my Analytics dataset I get two results for the same internal ID

same query in SuiteQL gets over 5000 results

one for each possible combination of subsidiary, currency, etc

but the record itself doesn't have a currency selected...

Why would the dataset in the UI return a different result set than SuiteQL?

modifying the query to SELECT DISTINCT cuts it down from over 5000 to around 100

the dataset is a big long xml file, not sure how to trim it down into SQL for pasting here

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_157960443690.html|SuiteQL.query>

Untitled

you want to pay attention to how the join is done

copy however netsuite does the join to get similar rows to what the dataset gets

Once I copied the way NetSuite did the join, I got identical results