I'm seeing duplicate records by internalid when selecting from CompanyAddressBook using the Netsuite2.com source for SuiteAnalytics connect.
select *
from "Buster and Punch Limited"."Data Warehouse Integrator".CompanyAddressbook
where internalid in (
select internalid
from "Buster and Punch Limited"."Data Warehouse Integrator".CompanyAddressbook
group by internalid
having count(*)>1
);
The records are simple, and I can't see any reason there would be duplicates.
|addressbookaddress|defaultbilling|defaultshipping|entity|internalid|label|lastmodifieddate|
|------------------|--------------|---------------|------|----------|-----|----------------|
|7416009|T|T|4624297|7107634|-redacted addr 1-|2025-08-07 12:32:13.000|
|7416009|T|T|4624297|7107634|-redacted addr 1-|2025-08-07 12:32:13.000|
|8543799|T|T|6938924|10921165|-redacted addr 2-|2023-04-19 17:45:05.000|
|8543799|T|T|6938924|10921165|-redacted addr 2-|2023-04-19 17:45:05.000|
The internalid has been unique up until yesterday, has something changed?