Truncating multiple similar fields with different values

Bubskim — Fri, 09 Aug 2019 18:23:10 GMT

I need to have a specific name of a box truncate into 1. The text between is the name of the box with the type of alert like disk space.

load subfield([Sent By], 'specificname*Disk_Space*', 1), If(WildMatch([Sent By], '*specificname*:Disk_Space*'), TextBetween ([Sent By], 'specificnamewithnumbers*','')) as [specificname Disk Space],

so basically here is what I see the xx's are for security

multiple entries

PROBLEM -xxxxxxxx123: Memory is CRITICAL (FreeMemory=5%)

PROBLEM -xxxxxxxx123: Memory is CRITICAL (FreeMemory=6%)

PROBLEM -xxxxxxxx123: Memory is CRITICAL (FreeMemory=7%)

so these are all the same problem only with different memories moving up or down. I would like for them all to display as one entry.

topic Truncating multiple similar fields with different values in QlikView

Truncating multiple similar fields with different values