Forum Discussion

EaglesTony's avatar
EaglesTony
Post Prodigy
1 year ago
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...
Need Help
  • EaglesTony's avatar
    EaglesTony
    1 year ago

    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.

EaglesTony's avatar
EaglesTony
Post Prodigy
1 year ago

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))

ronrsnfld's avatar
ronrsnfld
Super User
1 year ago

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