https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601556#M209356 <P>I don't want to just display the data directly using stats. My raw data has alot of processing to do and using join i am joining all these processed results. Is there any solution other than this?</P> Mon, 13 Jun 2022 13:49:38 GMT anooshac 2022-06-13T13:49:38Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601534#M209348 <P>Hi all, i have some data task name, execution date, link uploaded earlier. Now i want to add some more data related to the task name they are component name, number of components. If i upload the 2nd data in the form task name , component name, number of components will i be able to get all data together based on one common field task name. Can anyone knows is there any solution for this?</P> <P>My data are task name, execution date, link and the next set of data&nbsp; is task name , component name, number of components.</P> Mon, 13 Jun 2022 20:14:37 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601534#M209348 anooshac 2022-06-13T20:14:37Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601539#M209350 <P>Yes, you can either use join or stats by task name to aggregate the values from the fields on a common take name.</P> Mon, 13 Jun 2022 12:53:16 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601539#M209350 ITWhisperer 2022-06-13T12:53:16Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601556#M209356 <P>I don't want to just display the data directly using stats. My raw data has alot of processing to do and using join i am joining all these processed results. Is there any solution other than this?</P> Mon, 13 Jun 2022 13:49:38 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601556#M209356 anooshac 2022-06-13T13:49:38Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601562#M209360 <P>Stats, just like any command, works on the events in the pipeline; you can choose where you put the stats command; you can have more than one stats command if that helps your use case.</P> Mon, 13 Jun 2022 14:09:18 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601562#M209360 ITWhisperer 2022-06-13T14:09:18Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601697#M209414 <P>when i use stats all the data including the data i don't want to display also shows. How to avoid these? I tried by putting table command after stats for the selected data but that doesn't work.</P> Tue, 14 Jun 2022 09:57:42 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601697#M209414 anooshac 2022-06-14T09:57:42Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601699#M209415 <P>The table command can be used to limit the fields/columns - the where command can be used to limit the event/rows</P> Tue, 14 Jun 2022 10:01:30 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/601699#M209415 ITWhisperer 2022-06-14T10:01:30Z https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/602227#M209624 <P>Okay. Thank you so much.</P> Fri, 17 Jun 2022 11:08:00 GMT https://community.splunk.com/t5/Splunk-Search/How-to-combine-data-based-on-a-common-field/m-p/602227#M209624 anooshac 2022-06-17T11:08:00Z