topic Re: How to merge text in Splunk table? in Splunk Dev

How to merge text in Splunk table?

ashanka — Tue, 17 Mar 2020 23:55:55 GMT

Have a table like this , how

Type Country

Reporting US
reporting CAN
Reporting IND
COnsolidated US
Consolidate CAN
Consolidated IND

How do i display as

Type Country

Reporting US
CAN
IND
Consolidated US
CAN
IND

Re: How to merge text in Splunk table?

manjunathmeti — Wed, 18 Mar 2020 01:48:10 GMT

Try this. This will display results exactly as you want.

| eval Type=if(Country="US", Type, Country), Country=if(Country="US", Country, "") 
| table Type, Country

If you want to group Country by Type, then use stats.

| stats values(Country) as Country by Type

Sample query:

| makeresults 
| eval _raw=" Type Country
Reporting US
reporting CAN
Reporting IND
Consolidated US
Consolidate CAN
Consolidated IND" 
| multikv forceheader=1 
| eval Type=if(Country="US", Type, Country), Country=if(Country="US", Country, "") 
| table Type, Country

Re: How to merge text in Splunk table?

anmolpatel — Wed, 18 Mar 2020 02:58:17 GMT

@ashanka as such:

| makeresults 
| eval _raw = "Type Country
Reporting US
reporting CAN
Reporting IND
COnsolidated US
Consolidate CAN
Consolidated IND" 
| multikv forceheader=1 
| eval Type_new = upper(substr(Type, 0, 1)) + lower(substr(Type, 2)) 
| eval Type = case(match(Type_new, "Reporting"), "Reporting", match(Type_new, "Consolidate(d)?"), "Consolidated")
| stats list(Country) as Country By Type

This will return: