Hi Deepak, Thanks!
However, counting commas would not help me at this point. I want to know how many times a particular country name has appeared in the dataset. For example, here the USA alone has 638 counts (Column name-distinct counts), and it is paired with other countries a few times. I want to know the total number of counts the USA is appearing.
1 of 1 people found this helpful
No Worries, I learnt Something new Doing That!!
Well, Here it is and USA is 652 not 647 as you say. Solution is you need a Cartesian Join on 1:1. I downloaded all countries list from Net and then Used a Filter To Get You what you need.
Here Is breakup for USA 652
If it Helps, Please mark it Helpful and CORRECT to close Thread
Thanks, Deepak! This is awesome. Appreciated!