Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
×
Join the Conversation
Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
- Find Answers
- :
- About shreyp
shreyp
Explorer
Member since:
09-23-2022
11-10-2022
Community Statistics
| Posts | 9 |
| Solutions | 1 |
| Karma Given | 3 |
| Karma Received | 0 |
| Member Since | 09-23-2022 |
Activity Feed
- Posted Re: How to split a column into two based on condition? on Splunk Search. 11-10-2022 12:20 PM
- Karma Re: How to split a column into two based on condition? for gcusello. 11-10-2022 11:13 AM
- Karma Re: How to split a column into two based on condition? for johnhuang. 11-10-2022 11:13 AM
- Karma Re: How to split a column into two based on condition? for gcusello. 11-10-2022 11:13 AM
- Posted Re: How to split a column into two based on condition? on Splunk Search. 11-10-2022 10:05 AM
- Posted Re: How to split a column into two based on condition? on Splunk Search. 11-10-2022 10:00 AM
- Posted Re: How to split a column into two based on condition? on Splunk Search. 11-10-2022 08:53 AM
- Posted Re: How to split a column into two based on condition? on Splunk Search. 11-10-2022 08:43 AM
- Posted Re: How to split a column into two based on condition? on Splunk Search. 11-10-2022 08:24 AM
- Posted Re: How to split a column into two based on condition? on Splunk Search. 11-10-2022 08:21 AM
- Posted How to split a column into two based on condition? on Splunk Search. 11-10-2022 07:09 AM
- Tagged How to split a column into two based on condition? on Splunk Search. 11-10-2022 07:09 AM
- Tagged How to split a column into two based on condition? on Splunk Search. 11-10-2022 07:09 AM
- Tagged How to split a column into two based on condition? on Splunk Search. 11-10-2022 07:09 AM
- Posted Re: mvexpand multiple multi-value fields? on Splunk Search. 09-23-2022 01:07 PM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 |
11-10-2022
12:20 PM
To confirm, @johnhuang - your solution works as well! Thank you!
... View more
11-10-2022
10:05 AM
I was able to solve the problem using @gcusello's snippet along w/ a left join. <base_search>
| bin span=1d _time
| eval column=strftime(_time,"%d/%m")."-".Fruit
| join type=left column
[
| <same_base_search>
| bin span=1d _time
| eval column=strftime(_time,"%d/%m")."-".Fruit
| chart values(bad_count) AS bad_count OVER column BY Seller
] Thanks, all.
... View more
11-10-2022
10:00 AM
Thanks, I'll try this as well.
... View more
11-10-2022
08:53 AM
I've put dashes there to indicate the separation between the columns. Input table has 4 columns and the output table should have 6 columns (after adding X_bad_count and Y_bad_count). You could ignore the dashes or replace them with | , if it helps.
... View more
11-10-2022
08:43 AM
I'm sorry, I can't leak the exact data as it is critical to the organization. I've masked the use case and the variable names to the best of my ability. However, I can make it clear that the counts require no aggregation, only the table layout needs to be changed.
... View more
11-10-2022
08:24 AM
Hi @johnhuang Thanks for the response. The sum command is not helping in this case. I changed it to values() and it seemed to work but only if I filter for a particular Fruit on a particular day. Sincerely, Shrey
... View more
11-10-2022
08:21 AM
Hi Giuseppe, Thanks for the response. This almost did it! As expected, the chart command outputs in "column - X_bad_count - Y_bad_count" format. How do I append these two count columns back into the main table? I'm looking for a view that we would get from eventstats kind of command. Thanks, Shrey
... View more
11-10-2022
07:09 AM
Hi all, Pls consider this subset of data, ... - Date - Fruit - Seller - Bad_count - ... 11/8 - Apple - X - 3 11/8 - Apple - Y - 10 11/8 - Apple - X - 3 11/8 - Apple - Y - 10 11/8 - Orange - Y - 6 11/8 - Orange - X - 1 11/8 - Orange - Y - 6 11/9 - Apple - X - 0 11/9 - Apple - Y - 9 11/9 - Apple - X - 0 11/9 - Orange - X - 7 11/9 - Orange - Y - 2 How to read it => Row 1: On 11/8 Seller X had 3 bad Apples, Row 8: on 11/9 Seller X had 0 bad Apples. I would like to reformat the table into this: ... - Date - Fruit - Seller - Bad_count - X_bad_count - Y_bad_count - ... 11/8 - Apple - X - 3 — 3 - 10 11/8 - Apple - Y - 10 — 3 - 10 11/8 - Apple - X - 3 — 3 - 10 11/8 - Apple - Y - 10 — 3 - 10 11/8 - Orange - Y - 6 — 1 - 6 11/8 - Orange - X - 1 — 1 - 6 11/8 - Orange - Y - 6 — 1 - 6 11/9 - Apple - X - 0 — 0 - 9 11/9 - Apple - Y - 9 — 0 - 9 11/9 - Apple - X - 0 — 0 - 9 11/9 - Orange - X - 7 — 7 - 2 11/9 - Orange - Y - 2 — 7 - 2 How to read this => Row 1: On 11/8 for Apples: Seller X had 3 bad count and Seller Y had 10 bad count. The idea is to split the Bad_count column into two columns based on the unique combination of Date and Fruit. Any help would be greatly appreciated! Thanks, Shrey PS: 1) There's years of data, many many fruits, and multiple sellers in the original dataset. 2) I've also sorted the sample data by Fruit up there to make it easy to read. 3) Don't worry about the duplicate rows as there are other fields in the dataset as well (meaning, dedup with care).
... View more
09-23-2022
01:07 PM
Hi @to4kawa This method works perfectly if there is only one row. Would it be possible to make it work for multiple rows? | makeresults
| eval x="another_single_value_field"
| eval f1=split("a1,a2,a3",",")
| eval f2=split("b1,b2,b3",",")
| eval f3=split("c1,c2,c3",",")
| eval f4=split("d1,d2,d3",",") | append [ | makeresults
| eval x="another_single_value_field"
| eval f1=split("x1,y2,z3",",")
| eval f2=split("x1,y2,z3",",")
| eval f3=split("x1,y2,z3",",")
| eval f4=split("x1,y2,z3",",") ] Thanks!
... View more
