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