Forum Discussion

wr2013's avatar
wr2013
Copper Contributor
Mar 16, 2024

Counting the number of occurrences of an entity in a table

I am trying to automate the counting of the number of times a country appears in a table.  See below example.              This table is original.                                                    ...
excel
Formulas and Functions
peiyezhu's avatar
peiyezhu
Bronze Contributor
Mar 16, 2024

select * from splitCell;
cli_split_data~splitCell~[;,]~ROAD NAMES (EDITOR);
select `ROAD NAMES (EDITOR)`,count(1) from splitCellsplit group by `ROAD NAMES (EDITOR)`;

https://e.anyoupin.cn/EData/?s=1165

Resources