Splunk Search

How to break down multiple values into new columns dynamically?

vijay_k
Observer

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
0 Karma
Get Updates on the Splunk Community!

What’s new on Splunk Lantern in August

This month’s Splunk Lantern update gives you the low-down on all of the articles we’ve published over the past ...

Welcome to the Future of Data Search & Exploration

You have more data coming at you than ever before. Over the next five years, the total amount of digital data ...

This Week's Community Digest - Splunk Community Happenings [8.3.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...