Hi, Extract fields did work for me as mentioned base search | extract mv_add=t pairdelim="," kvdelim="=:" | table <>
. However in a single transaction records there is duplicates of the same <> like as you in the above string OfferIds gets repeated, partnerId gets repeated.
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
base search | extract mv_add=t pairdelim="," kvdelim="=:" |dedup ActivationId,partnerId,userId,offerIds,activationType,activationDate,channel | table ActivationId,partnerId,userId,offerIds,activationType,activationDate,channel
... View more