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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive