Forum Discussion
Solved
How can I group like rows ?
I have a table with the following: NAME KEY Added DATA-123 Removed DATA-123 Committed DATA-456 Added DATA-789 What I need is to know if the KEY has a Removed, to filter t...
I decided on making a clone of the table and just having "removed" in there and merge it back and filter out those records with Key as null, it appears to work and needed to have this due to time sensitivity, but thanks all for your assitance and ideas.
It is taking quite awhile to get records back.
Also, Name has other than Committed, Removed, Added. Some are just junk values.
I don't know what you mean, nor how it relates to your question. You don't provide sufficient information for me to comment.
"It is taking quite awhile to get records back"
- From what step?
- How long?
- what are the errors if any?
- If your data source is slow, that would certainly be a cause.
"Also, Name has other than Committed, Removed, Added. Some are just junk values".
- How does that relate to your original question?
- The code I provided does what you stated in your original question, which was to remove KEYs if there were any NAME="Removed" listed with any one of the KEYs.