Forum Discussion
Solved
Remove duplicate and control which row stays
Hi! I have a pretty simple query, two columns. Column A is the name of a school and column B is an ID number. I want to remove the duplicate ID number, but keep the row that has the shortest name. T...
NewStep=Table.FromRecords(Table.Group(PreviousStepName,"ColumnB",{"n",each Table.Min(_,each Text.Length([ColumnA]))})[n])
this code only feedback two columns.
how about the table have three or more columns?
I have only tested it with the sample data.
I was just very surprised that List.Min([Name]) is evaluated.
Can you explain this?
Greetings Mel