Netsuite Analytics Connect

Looking for guidance on what other users are doing with Netsuite Analytics Connect. For example, I have a table of transactionline and transactionaccountingline. Each of these tables is 9mm rows and I need to join them together to get a master transaction table.
I was hoping to do this in the native connector but it looks like you can't join tables together in the source ( sql below )
Any thoughts from Suite Analytics users ? I'm just looking for a way to reduce rows / optimize credit usage. If there is a way to do this in Netsuite then feed to the Domo connector I'm open to that as well.
SELECT
TL.TRANSACTION
,TL.ID
,TL.UNIQUEKEY
,AL.ACCOUNT
,AL.POSTING
,AL.DEBIT
,AL.CREDIT
,AL.AMOUNT
,AL.NETAMOUNT
FROM TRANSACTIONLINE AS TL
LEFT JOIN TRANSACTIONACCOUNTINGLINE AS AL
ON TL.TRANSACTION=AL.TRANSACTION
AND TL.ID = AL.TRANSACTIONLINE
Best Answer
-
To answer my own question, the script above actually works via suiteanalytics connect in Domo
0
Answers
-
Have you tried using the TBA connector with a custom saved search?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith the saved search connector is terribly slow. I've seen run times of > 12 hours for under a million rows so that isn't an option
0 -
To answer my own question, the script above actually works via suiteanalytics connect in Domo
0 -
@calvert_schaefer looks like you have potentially found a solution but if you are still having issues let me know, I went through a lot of pain getting NetSuite and DOMO connected through Analytics connect but feel like I have a pretty good grasp on it now.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive