Forum Discussion
How can I group like rows ?
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.
Assuming Custom1 step shows the table similar to what you show in your original question, had you done what I have suggested, you should have something like:
let
Source = OData.Feed(your data source),
Custom1 = Source{[Name="Labels",Signature="table"]}[Data],
#"Filtered Rows" = Table.SelectRows(Custom1, (r)=>
let
allKeys = Table.SelectRows(Custom1, each [KEY] = r[KEY])
in
not List.Contains(allKeys[NAME],"Removed",Comparer.OrdinalIgnoreCase))
in
#"Filtered Rows"
which would show your stated desired result.
I have this, but it seems to take quite awhile to refresh:
= Table.SelectRows(Custom1, (r)=>
let
allKeys = Table.SelectRows(Custom1, each [KEY] = r[KEY])
in
not List.Contains(allKeys[NAME],"Removed",Comparer.OrdinalIgnoreCase))
That seems almost identical to what you wrote previously. I had given you a list of possibilities for slowness. I am afraid that without access to a data set example that can reproduce the problem, I don't know what to add about the slowness.
Seems similar to what you've posted before, and what I've responded to.
If the source of the slowdown is not clarified by my previous response, I don't think I'll be able to assist further without access to a sample database that illustrates the problem.
It could be your data source, the code in your own system, the size of the database, any number of things. But no way to troubleshoot without more inforrmation