TICKScript - combine fields and text to one output


#1

I have a TICKScript where I process for alerts and then save to another database. How can I get two metrics to save as one output?

I.E.

var data = stream
|from()
.database(db)
.retentionPolicy(rp)
.measurement(measurement)
.groupBy(groupBy)
.where(whereFilter)
|eval(lambda: “HeapMemoryUsage.used”, lambda: “HeapMemoryUsage.max”)
.as(‘used’, ‘max’)

trigger
|eval(lambda: concat(“used”," out of: ",“max”) )
.as(‘value’)
|influxDBOut()
.create()
.database(outputDB)
.retentionPolicy(outputRP)
.measurement(outputMeasurement)
.tag(‘alertName’, name)
.tag(‘triggerType’, triggerType)