Qlik Community

Qlik Sense Cloud Discussions

Highlighted
jvandamme
New Contributor

Categorizing Data text in buckets

Hi,

i have a data set with Error discriptions that i would like to categorize in to buckets but i can't figure out how to do this.

in some case there is already a category put in front of the text but this is not the case for all errors.

Knipsel.PNG

Can someone help me?

thank you.

2 Replies

Re: Categorizing Data text in buckets

Would you be able to share this data in an Excel file and provide the output you expect to see (the buckets each line would fall into)?

jvandamme
New Contributor

Re: Categorizing Data text in buckets

Hi Sunny,

most of them should fall in to the bucket mentioned in the beginning of the text ([STM],[WHSEST]). Only a smaller portion of text lines have no bucket in front of them.

i will try to attach a data example.

thank you.