Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

Add a row counter to your data

  • 1.  Add a row counter to your data

    Posted 11-29-2016 18:05

    It's often useful to add a unique row identifier to your data, especially as not all data sets will have one and it provides a handy way to refer to a data record. 

    You can add one easily in Dataverse using the built-in variable execCount. 

    For example, in a Transform node, I can use "emit execCount as row_id" and this creates a counter in a new column called "row_id".

    Reference: https://d3sa-preview.infogixsaas.com/dist/help/Default.htm#f-script/built-in-variables.htm#execCoun