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.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 283 Workbench
 4 Cloud Amplifier
 4 Federated
 2.7K Transform
 90 SQL DataFlows
 569 Datasets
 2K Magic ETL
 3.4K Visualize
 2.4K Charting
 601 Beast Mode
 15 App Studio
 29 Variables
 600 Automate
 151 Apps
 418 APIs & Domo Developer
 29 Workflows
 2 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 363 Distribute
 99 Domo Everywhere
 262 Scheduled Reports
 2 Software Integrations
 98 Manage
 95 Governance & Security
 15 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 90 Community Announcements
 4.8K Archive