Splunk Search

Transpose command causes other columns to be displayed as rows?

rkassabov
Path Finder

I am having issues with the QuestionText fields in my query below. I am trying to take all the QuestionText entries and display them as columns, however after transposing those fields, the other columns I had listed for my table have become rows. How can I transpose the QuestionText fields while keeping my other columns and not getting that mysterious "column" at the beginning of my table? See below:

index=xxx source=xxx   
| dedup QuestionID 
| eval QuestionText= SectionTitle + " " + QuestionText 
| sort QuestionID 
| table "Date Created" "Created By" "Vendor Name" "Risk Rank ID" Criticality "Risk Rank Score" QuestionText QuestionAnswer 
| transpose 0 header_field=QuestionText

alt text

Tags (1)
0 Karma
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...