Group field values in Qlik Sense?

[#1]

I'm trying to analyze some dirty data and I'd like to create a custom group where I can select the various spellings of one vendor's name into a single value.  What's the easiest way to do this in Qlik Sense?

Thanks,

[#2]

Hi Kathy,

One way to accomplish that is by using an INLINE table in the Script Editor so you can group many values into your grouping values.

Like this:

// previous LOAD sentences...

MyGroups:

LOAD * INLINE [

Group, DirtyName

Group A, foo1

Group A, foo2

Group B, foo9

];

Then you can use the field "Group" in a sheet to filter your data and also as a Dimension in a chart.