How to group distinct values into a single level array Laravel

Question

Is it possible to group distinct table values using an array of columns - to group by each individual column. For example:

$columns = ['column1','column2','column3'];
$array = Model::select($columns)->distinct()->get()->groupBy($columns)->keys();

And I would like this to return (obviously my code isn't accurate and i'd like a way to do this without a for loop... I feel collections have the functionality to do this):

[ 
  'column1' => [...distinct column1 values],
  'column2' => [...distinct column2 values],
  'column3' => [...distinct column3 values],
]

Martin Dimitrov · Accepted Answer · 2020-02-11 11:21:00Z

1

This should do the work. You had switched the places of get() and groupBy()

$columns = ['column1','column2','column3'];
$array = Model::select($columns)->distinct()->groupBy($columns)->get()->keys();

answered Feb 11, 2020 at 11:21

Martin Dimitrov

1,3041 gold badge11 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to group distinct values into a single level array Laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related