Hi to all,
I have two columns named as Country and Zip Code
I want to count number of rows for each combination so that I will be able to find most frequent zipcode for each country to fill null zipcodes.
It is the equivalent of SQL code count(x) over (partition by y,z)
I tried Groupby and Column Aggregator but couldn’t find an output such as : “Country” - “Zip” - “Count”
Is there a suitable way for it?
Thanks,
Have a nice day
1 Like
Sorry for taking your time,
I still want to see your different approaches.
But I found the solution. It is with Groupby again.
I added these two columns as grouping variables but I also needed to count another column in manual aggregation tab.
It is OK for me now. Sorry again
2 Likes
ScottF
3
No need for apology! It is always helpful to see a problem posted, with the solution immediately after
Incidentally, what you ended up doing is what I would have suggested.
system
Closed
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.