Count by Group and retain all colums

Hi, I’m trying to use the Count by Group step but can’t see how I can use that and retain all the columns in the Input table. See the input and the results in the screen shot.
What am I missing? :grinning:

Hi @Mark_Berry - The Count by group step will only keep the columns that are being referenced in the settings. If you want to pull those results into the original data set, you can use a Combine tables step to pull in the Count by group results and the original input.

I hope that helps but let me know if you have any questions!

1 Like