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)
Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes
and swag!