Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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