I have the following test table and I would like to have the following result, see below. RecordIDNameValue175301 75302 75303Test_Text175304 56401 56402 56403Test_Text256404 56405 RecordIDNameValue175301 75302 75303Test_Text156401 56402 56403Test_Text2 I have created or used a transpose for a dynamic hierarchy. But now I want to delete the rows that are larger in name than their name, where there is a value in it.

Need to delete rows based on calculation and values in other rows

I have the following test table and I would like to have the following result, see below.

I have created or used a transpose for a dynamic hierarchy.

But now I want to delete the rows that are larger in name than their name, where there is a value in it.

Developer

Parse

Preparation

Optimization

Here is one way to get the expected output.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

unfortunately, not practicable, as the original database contains 14000 entries

Or let's talk from the beginning. Maybe there is a simpler version than mine.

The following initial situation:

Understood, for this amount of rows it is not a good idea to use the append. Try this one, i understand that this one has a much better performance.

Another and more performatic option to the original problem.

It worked?