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

Any good ideas for emulating/doing select distinct({lineuniquekey}) in a saved search without using summary?

We have two tables where a transaction is parent and both tables have a field for lineuniquekey.
The same transaction can exist in both tables but refer to different lines.
I need to pull out only the line that where the lineuniquekey is the same.
But since there are two joins, I get [the line with info from table A]*[number of lines in table B that are connected to the same transaction]

case when {fieldA.joinfield} = {fieldB.joinfield} then 1 else 0 end