Skip to Content
0
Former Member
Oct 25, 2012 at 01:12 PM

"Summarize an internal table"

456 Views

Hi,

I have a table containing table_names, e.g. PA0002, PA0003, PA0007 and PA0008. That table, however, has not four entries, but since I derive this from a SPLIT command out of another internal table, it has 445 entries - the total number of fields I have.

What I want now is actually two things:

- I want to make a compact table out of this with just 4 entries with my 4 distinct table_names and

- I want to get the count of lines belonging to any one of these tables - might be 70, 100, 90 and 185 or whatever.

I guess I could come up with a rather complex way of doing this in two nested LOOPs ... but since performance is an issue, I wonder, isn't there a simpler way to do this, with just one command?

Thanks a lot!

Best regards,

Sapperdapper