Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

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

Example:

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 New...