Identifying unique values in a field which are comma separated?

Question & Answer
,
1

How do I identify the unique values within a field, which are seperated by comma?

I have a data in the below format, where the need is to find out unique values. Note this information is in one field only

Source
AD, Spectrum
AD, Spectrum
AD, Spectrum
Vcenter, Spectrum
Vcenter, Spectrum
Vcenter, Spectrum
AD, SNOW, Cloud, Spectrum
AD, SNOW, Cloud, Spectrum
AD, SNOW, Cloud, Spectrum
Vcenter, SNOW, Cloud, Spectrum
Vcenter, SNOW, Cloud, Spectrum
Vcenter, SNOW, Cloud, Spectrum
Vcenter, AD, Spectrum
Vcenter, AD, Spectrum
Vcenter, AD, Spectrum

The desired output would visually provide information something like this:

Total Number of Unique sources : 05
Name of unique sources: AD,Spectrum,Vcenter,Cloud,SNOW

2

Is this field a string? Do you have access to create a custom field in the Quicksight dataset?

If so you may be able to use the split function to create a separate field for each item in the {Source} field and the do a count on each newly created fields and sum those values.

1 Like