I have setup Kapacitor to read a measurement and convert field of type string to lower case and output the transformed data to another measurement. The tag in the original measurement is getting stored as a field in the new measurement. How to retain tags when transforming data?
This is the .tick file that I am using:
dbrp "test"."autogen"
batch
|query('SELECT * FROM "test"."autogen"."store"')
.period(1d)
.every(30s)
|eval(lambda: strToLower("timezone"))
.as('timezone_lower_case')
.keep()
|InfluxDBOut()
.database('test')
.measurement('currentTime')
The original measurement “store” has a field “timezone” and a tag “storeId”. The new measurement has fields of “timezone”, “timezone_lower_case”, “storeId”.
The “storeId” tag got converted to a field
I want to retain “storeId” as tag in the new measurement