Hi, I have a table of workflow states:
As you can see, the “Name” column has many duplicates.
I want to add each unique value in the “Name” column as a new row in my new table. It should look something like this:
The above image was generated from looking at other forum posts and doing the “button method”. It has two issues in my opinion:
This is impractical for scalability since it needs manually pressed whenever new values are added
There is still a duplicate “Ready for Review” carried over.
The ideal solution here is a dynamically updated table that has rows that are populated from the original table by first converting the values to lowercase and then adding each unique value.
Here is my formula for the button if this helps at all:
- [Workflow States].Name.Unique().ForEach(AddRow(Table,Table.Name,CurrentValue))