Jump to content

Need to organize large dataset

Tracy Erkkila

Recommended Posts

I have a large (10M+ rows) dataset that I need to organize. This data is the result of combining several similar data tables into one large table. I would like to insert a calculated column that will indicate the "MemberID" for each entry in each Batch. Is there a formula/calculation that will do this


Batch MemberID

1 1

1 2

1 3

2 1

2 2

2 3


I know there are 131072 Members for each of 8 batches, and I want to simply repeat the MemberID for each batch. Each batch is in the same order, so essentially I just need to repeat 1 thru 131072 down for the 8 batches.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...