Reference to the row number in a beastmode
We are loading data from Domo exports into another system. We created a card that looks like our import file and simply export to Excel. The first set is 500,000 rows but must be uploaded in chunks of 20,000 rows each.
I wanted to create a column that gave me a number incremented in chunks of 20,000. This was simple in excel =IF(MOD(ROW(),20000)=0,1,0)+A1. a1 contains 0 so the first batch of records are "0", then "1" etc... Is there a way to reference the row number in a beast mode? I am sure there are other uses for accessing the row number in a beastmode....
Comments
-
Hey @WHM,
MySQL doesn't have a native row_number() function (I know that isn't what you're asking for) and to my knowledge it doesn't store row numbers in the metadata at all. (Could be wrong about this one).
So the short answer is no, row numbers cannot be referenced at the beast mode level natively.
I think the easiest solution here is probably going to be using a Dataflow to create a row number column using either a MySQL variable or a redshift Row_Number() windowed function, then using the output as your cardbuilding source.
Hope this is helpful.
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 384 Distribute
- 110 Domo Everywhere
- 268 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive