Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Bubskim
Contributor II
Contributor II

Truncating multiple similar fields with different values

 

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. 

 

 

0 Replies