Learning Alteryx: A beginner's guide to using Alteryx for self-service analytics and business intelligence by Renato Baruti

Author:Renato Baruti [Baruti, Renato]
Language: eng
Format: epub, pdf
Publisher: Packt Publishing
Published: 2017-12-26T00:00:00+00:00

Step 2: Select Create New Field, and enter this in the text box: RecordID.

Step 3: Select YearEnd from the Group By (Optional) options.

Step 4: Write the following expression:

[Row-1:RecordID]+1

Step 5: Add the Browse tool to the Multi-Row Formula tool.

Step 6: Run the workflow:

RecordID field takes the previous row value and adds 1 for each YearEnd noted by the YearEnd Group By selection. As soon as a new YearEnd is identified [Row-1:RecordID]+1 will start a new count. This is great for identifying records by a group. More than one group can be identified by selecting more than one Group By option.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.