Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Not applicable

Text search, match, and group

Example: Column 1 is my description and Column 2 is my grouping. How can I set a certain condition where it can differentiate what I'm grouping by from Column 1?

Column 1          Column 2       

1k                    k

1k                    k

1k                    k

2b                    b

2b                    b

2b                    b

2b,1k               bk

2b,1k               bk

2b,1k               bk

Any help would be appreciated.

Tags (1)
1 Reply
MVP
MVP

Re: Text search, match, and group

Maybe like

LOAD

   Column1,

   PurgeChar(Column1,'0123456789,') as Column2

FROM ...;