Best Practice to Deal with First Rows of Data

[ksiudut]

Hello!

New to Alteryx, but loving it!  I was wondering what the best way was to use Alteryx where the first row of data needs to have a different formula.  For example, I wanted to make a new column in my lookup table that would start at 1 for the first row of data and then 2 for 2nd row, and so on.  Any help would be greatly appreciated!

[cjaneczko]

Are you just looking to have a column that has 1 through n+1? If thats the case you can add a Record ID field to the workflow. Another method is a multi row formula tool where you start with 1 and add 1 to the previous record. 

[caltang]

Adding to @cjaneczko ‘s comment, you could consider pivoting your data with the Transpose and Cross Tab tools to make it even more dynamic. Just need to puzzle the columns to rows, then rows back to columns. 

Far more dynamic and helpful and combined with the multi row tool and record ID tool, it’ll be a super workflow.