| eval logMsgTimestampInit = logMsgTimestamp
| eval ID_SERVICE= mvappend(ID_SERVICE_1,ID_SERVICE_2) , TYPE= mvappend(TYPE1,TYPE2)
| table ID_SERVICE TYPE ID_SERVICE TYPE TIME asd232 mechanic_234 2023-12-01 08:45:00 afg567 hydraulic_433 cvf455 hydraulic_787 2023-12-01 08:41:00 bjf347 mechanic_343 2023-12-01 08:40:00 Hi Dears, I have the following issue, exists some cells (like in red) that is appearing with 02 values per cell, like the column ID_SERVICE, this is why the payload is containing 02 service id in the same message. What I need? I need split this cells everytime it occurs , I tried to use mvexpand but unfortunately it causes a mess in the table. When I try to use mvexpand it duplicates the rows and for each value in the first colum creates another row ...
| query_search
| mvexpand ID_SERVICE
| mvexpand TYPE
| table ID_SERVICE TYPE TIME ID_SERVICE TYPE TIME asd232 mechanic_234 2023-12-01 08:45:00 asd232 hydraulic_433 2023-12-01 08:45:00 afg567 mechanic_234 2023-12-01 08:45:00 afg567 hydraulic_433 2023-12-01 08:45:00 cvf455 hydraulic_787 2023-12-01 08:41:00 bjf347 mechanic_343 2023-12-01 08:40:00 Since the 01 row (in red) shares the same timestamp (TIME colum) I would like to split every value in a row and copy the same timestamp for both values and the desired output is like follows below: ID_SERVICE TYPE TIME asd232 mechanic_234 2023-12-01 08:45:00 afg567 hydraulic_433 2023-12-01 08:45:00 cvf455 hydraulic_787 2023-12-01 08:41:00 bjf347 mechanic_343 2023-12-01 08:40:00 Please, help me.
... View more