import csv file by merging multiple rows for a fie...

Getting Data In

Hello, I have a csv file that has the following format

ProductName, StringID,GUID,ServicePlans

A, AID,8f0c5670-4e56-4892-b06d-91c085d7004f,APlanA

,,,APlanB

,,,APLanC

B,BID,113feb6c-3fe4-4440-bddc-54d774bf0318,BPlanA

,,,BPlanB

I want to import the csv in a such way that rows with empty fields in ProductName are merged on the non empty filed field ServicePlans

the result will be two rwo events

A, AID,8f0c5670-4e56-4892-b06d-91c085d7004f,APlanA APlanB APlanC

B,BID,113feb6c-3fe4-4440-bddc-54d774bf0318,BPlanA BPlanB

can you provide a help with props.conf

Get Updates on the Splunk Community!

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...

Struggling with alert fatigue or feeling like you're spending more time on infrastructure maintenance than ...

Organizations today are generating more data than ever and storing it across cloud object stores, data lakes, ...

import csv file by merging multiple rows for a field in a single row