Base String is -----------------
Use this command to extract fields for above string
| extract mv_add=t pairdelim="," kvdelim="=:" | table fields
. However in a single transaction, there is duplicates of the same field like as you see in the above string OfferIds gets repeated, partnerId gets repeated. I just need only once in the output .
When I try to dedup offerId, partnerId after extracting and then table, it does not work. Any help would be appreciated to remove the duplicates
Tried
base search | extract mv_add=t pairdelim="," kvdelim="=:" |dedup ActivationId,partnerId,userId,offerIds,activationType,activationDate,channel | table ActivationId,partnerId,userId,offerIds,activationType,activationDate,channel
Try this
base search | extract mv_add=t pairdelim="," kvdelim="=:" |eval partnerId=mvdedup(partnerId | eval ActivationId=mvdedup(ActivationId) | table ActivationId partnerId
Try this
base search | extract mv_add=t pairdelim="," kvdelim="=:" |eval partnerId=mvdedup(partnerId | eval ActivationId=mvdedup(ActivationId) | table ActivationId partnerId