This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am wanting to create a sequence counter from the input data below so i know how many interations of a loop to run in a later process in order to correctly apply the change records.
I create for each student an index from 1- n and then pick the max (index) across all students . We then run through our later loop first applying all the index no(1) records then the index no(2) records etc until we hit the max (index no)
Can this task be performed with less components than the below? The formula simply adds a column with an integer containing the value (1) in it for every record.the summarize then sums these for each student . i.e if there are three records for a student then three 1s will appear and be totalled =3. using a component just to add a dumb counter column full of 1s seems a little inelegant!