Count values

anatol · Posted: Fri Nov 04, 2016 11:21 pm

Hi,

If I have file ( fb 80)

Arun Raj · Posted: Fri Nov 04, 2016 11:32 pm

anatol · Posted: Fri Nov 04, 2016 11:39 pm

SEQNUM gives me 1,2,3,4,5 or I can RESTART for value and it will give 1,1,2,1,2 but I need 1,1,2,2,3

Arun Raj · Posted: Fri Nov 04, 2016 11:41 pm

You need to have 2 SEQNUMs - one for each key and OVERLAY at the same position (with no RESTART). Good luck.

RahulG31 · Active User Joined: 20 Dec 2014 Posts: 446 Location: USA

anatol,

Arun had mentioned a very simple solution (2 lines). I think that will work only if you know what the input values could be. That means it will be specific to the Input values. So,

First question: Do you have only 2 values 'INT', 'NRT' in the input or you can have many (probably hundreds?)

Second: Do you already know beforehand that the values are going to be 'INT' and 'NRT' (or anything else). Or you don't know and you would want a generic solution.

.

enrico-sorichetti · Posted: Sat Nov 05, 2016 4:10 am

You will have to run a multi stage process ...

the first stage will overlay somewhere a global sequence number to remember the original sequence

the second stage will sort on the key adding a sequence/count number for each key

the third stage will sort on the global sequence number to restore the original sequence

Bill Woodger · Posted: Sat Nov 05, 2016 4:20 am

Arun's solution will do exactly what has been articulated by TS/OP.

I don't see the point in inventing scenarios beyond what the TS/OP comes up with (when it is clear and consistent with what is shown), especially a multi-pass/multi-sort solution where, counter to other recent commentary, a program may turn out to be a more efficient solution.

Let's clarify the question, answer the question. In that order.

anatol · Posted: Sat Nov 05, 2016 4:23 am

Hi ,

The values not limited just INT & NTR ... it could be other ... you are right - I need generic solution ... and btw, this is group for the same key it could be other group for other key ... sorry didn't put key in first request (AAA, BBB are the keys)

Bill Woodger · Posted: Sat Nov 05, 2016 4:37 am

Great.

Please, you are not new here, and you've asked questions recently with the same issues of poor description, so don't, ever, do that again. Ask with all the information, representative sample data, expected output, the output you get from what you have tried, and what you have tried.

So how many different values do you have? Are they fixed, or can someone add a new value at any random moment?

Why do you want the sequence numbers? It doesn't make the records look any prettier, and anyone processing the file can more easily "create" the sequences on the fly. What is the overbearing purpose of having this?

Don't generate your own chit-chat (chit-chat in "Frequently Asked/Off-topic" questions) and don't respond to the chit-chat of others.

enrico-sorichetti · Posted: Sat Nov 05, 2016 5:54 am

anatol · Posted: Sat Nov 05, 2016 6:41 pm

Thank you all ... I will go with Enrico solution