I need to exclude the Bold rows in the next table where I load them.
The logic behind this is: I need to exclude the combinations where I see [1] , [2] or [3]
if it is [1] in ID, I'm adding E as value.
the data is concatenated thereafter.
So, a value of [1][4][5] will have values as : E||
Again, coming back to the original ques, I need to exclude all those ID's where Value starts and ends with E and there is no || (double pipe) in between.
Could anyone suggest a process to do so? Help would be much appreciated.
