×

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.
Ask a Question
sultanulariff
Engager
Member since: ‎05-25-2024
‎05-25-2024
Community Statistics
Posts 4
Solutions 0
Karma Given 0
Karma Received 0
Member Since ‎05-25-2024
View All

Re: Add row in table if value not present in the f...

by in Splunk Search
‎05-25-2024 12:02 PM
‎05-25-2024 12:02 PM
Hi @tscroggins , there are only 3 possible values i.e. Bag_Type = "Local","Transfer","Rush".  The requirement is every flight for specific date shall have 3 rows with baggage volumes. If any row is missing from source data, I need to create the particular row with baggage volume as "0". ... View more

Re: Add row in table if value not present in the f...

by in Splunk Search
‎05-25-2024 11:57 AM
‎05-25-2024 11:57 AM
Hi @tscroggins , many thanks for the response. Looks perfect! Will need to try it with the actual data/query and reconfirm.  ... View more

Re: Add row in table if value not present in the f...

by in Splunk Search
‎05-25-2024 11:50 AM
‎05-25-2024 11:50 AM
Hi @PickleRick , there are three bag_types 1. Local 2. Transfer and 3. Rush From the actual source data, I do not get all three 'Total processed' baggage counts (i.e. there shall be 3 rows for every single Airline/Date) every time. Hence, if any of the three bag_type is not there, I need to create a row for the missing Bag_type with Total_Processed=0. I use above index as base search query and left join further sub queries. For example, if 03/05/2024,IX,Transfer,0 is missing I am not able to join the sub queries related to 03/052024,IX,Transfer. So, I need it as a seperate/new row (if the row is missing) ... View more

Add row in table if value not present in the field

by in Splunk Search
‎05-25-2024 06:39 AM
‎05-25-2024 06:39 AM
I have table as below  Date Out Airline Bag Type Total Processed 01/05/2024 IX Local 100 01/05/2024 IX Transfer 120 02/05/2024 BA Local 140 02/05/2024 BA Transfer 160 03/05/2024 IX Local 150 Whenever a Bag Type is missing for certain Airline (in above case Transfer data is missing for 03/05/2024 IX). I need to create a manual row entry with value as 0 (Total Processed = 0) Date Out Airline Bag Type Total Processed 01/05/2024 IX Local 100 01/05/2024 IX Transfer 120 02/05/2024 BA Local 140 02/05/2024 BA Transfer 160 03/05/2024 IX Local 150 03/05/2024 IX Transfer 0 ... View more
Labels
Contact Me
Online Status
Offline
Date Last Visited
‎05-25-2024 03:23 PM