LISTAGG or equivalent during data import from NetSuite
What SQL should I be using during an import to collapse data from a column into ',' delimited strings?
when I use:
listagg(item.NAME,',') "ITEM(S)",
I get the error:
[NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# l27jpdhw1857xj1xsmvi0[400]
with just item.NAME "ITEM(S)", I get multiple rows per 'user' each row with a single item.
I've tried group_concat() also.
Please help.
Answers
-
Those functions are aggregates, are you grouping your data on your other columns?
Have you tried just utilizing a MagicETL dataflow after import and using the group by tile and selecting to combine values with commas?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
This is the only data element that has multiple rows in the data everything else is 1 row per 'user'. I was hoping to be able to do this during the import process. It's a pretty standard SQL function.
If I can't make it work during import, the next step is to aggregate after import. It looks I can do it in the 'Add Formula' or 'Group By' Magic Tiles.
0 -
@mberkeley the SQL driver is built by Netsuite.
Netsuite would have to build that functionality into the driver before Domo's connector would support it.
Also purely from a best practices point of view it might make sense to import the data as is. yes it does lead to higher data volumes, but in Domo for filtering purposes having the values spread across rows enables the use of filter cards. (multi select "find all rows with permutations that contain foo" isn't natively supported without a lot of user clicking.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive