Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
How to connect two Datasets in a Workbook
With version 2021.2 SuiteAnalytics brought an option of using fields from two dataset in one Workbook table, pivot table or a chart. Because the connection (linking, joining..) needs to be defined via SuiteScript to appear in Workbook UI, I thought an example can be handy for your experiments.
Before you start coding, make sure to do the following:
- Enable the Client SuiteScript and Server SuiteScript features at Setup > Company > Enable Features > SuiteCloud.
- Register SuiteScript plug-ins for SuiteAnalytics to display defined datasets and workbooks in the UI. For more information, see:
- Take a look at the documentation for the three main SuiteScript modules:
1