Archive2

Unable to break my data into multi line rows in Splunk

Path Finder

Hello Splunkers,

I need your help to break my data into multi line rows. I have copied sample data where Ist row is column names.

Epic Feature key Project fixversions issuelink_inward issueid_inward
SC - Stateroom STATE-750 Connected Stateroom State Room App Version 1.1 Test STATE-2226
Guest App 1.12

SC - Suites STATE-707 Connected Stateroom State Room App Version 1.1 Test STATE-2201
Guest App 1.12 Test STATE-2238

I want to display the output as below. Only fixversions column having multi values.

Epic Feature key Project fixversions issuelink_inward issueid_inward
SC - Stateroom STATE-750 Connected Stateroom State Room App Version 1.1 Test STATE-2226
SC - Stateroom STATE-750 Connected Stateroom Guest App 1.12 Test STATE-2226

SC - Suites STATE-707 Connected Stateroom State Room App Version 1.1 Test STATE-2201
SC - Suites STATE-707 Connected Stateroom Guest App 1.12 Test STATE-2201
SC - Suites STATE-707 Connected Stateroom State Room App Version 1.1 Test STATE-2238
SC - Suites STATE-707 Connected Stateroom Guest App 1.12 Test STATE-2238

https://ibb.co/dxFBFf

Your help will be appreciated!

Thanks.

Tags (1)
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!