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
 10.5K All Categories
 6 Connect
 916 Connectors
 250 Workbench
 463 Transform
 1.7K Magic ETL
 69 SQL DataFlows
 476 Datasets
 189 Visualize
 252 Beast Mode
 2.1K Charting
 11 Variables
 17 Automate
 354 APIs & Domo Developer
 89 Apps
 3 Workflows
 20 Predict
 5 Jupyter Workspaces
 15 R & Python Tiles
 246 Distribute
 62 Domo Everywhere
 243 Scheduled Reports
 21 Manage
 42 Governance & Security
 172 Product Ideas
 1.2K Ideas Exchange
 11 Community Forums
 27 Getting Started
 14 Community Member Introductions
 55 Community News
 4.5K Archive