How to count value from Comma Separated text

[Ravi_Nagmal]

Hi Folks,

Urgent help required, I am trying to achieve Required Table which the source data I have.

Please help, Thanks in Advance.

[steeefan]

Break up the field Team name with SubField(),  then on Record No perform a COUNT() while GROUPing over Team name.

[Pierrick]

Hello,

if you can modify your data in your datamodel, you can use the subfield function : subfield documentation 

In your load script, is like : 

Load
    [Record No],
    subfield([Team name],',') as Team
Resident Data;

You'll get a line for each key "Record-Team", and in the visualization, you can easily count the number of records per team.