Splunk Search

How to break down multiple values into new columns dynamically?

vijay_k
Engager

I have column with Multiple Values separated by new line character

Type is the column

 ID     Type

         Type_A

01     Type_B

          Type_C

I need new columns with values 1 or 0 for row (with ID 01) based on its presence for Type

ID       Type            Type_A          Type_B       Type_C

            Type_A           1                       1                    0

01      Type_B

 

02       Type_A

             Type_B

              Type_C

Labels (1)
Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| eval Type=split(Type,"
")
| chart count by ID Type
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

.conf25 Global Broadcast: Don’t Miss a Moment

Hello Splunkers, .conf25 is only a click away.  Not able to make it to .conf25 in person? No worries, you can ...

Observe and Secure All Apps with Splunk

 Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What's New in Splunk Observability - August 2025

What's New We are excited to announce the latest enhancements to Splunk Observability Cloud as well as what is ...