https://community.splunk.com/t5/Splunk-Search/How-to-give-matching-fields-the-same-number/m-p/592194#M206133 <LI-CODE lang="markup">| streamstats dc(Key) as Number</LI-CODE> Mon, 04 Apr 2022 11:45:03 GMT ITWhisperer 2022-04-04T11:45:03Z https://community.splunk.com/t5/Splunk-Search/How-to-give-matching-fields-the-same-number/m-p/592190#M206132 <P>Hello, I have data that look like this :</P><LI-CODE lang="markup">Month Key Value Number ------------------------------ Jan Key1 50 1 Feb Key1 57 2 Mar Key1 51 3 Jan Key2 101 4 Feb Key2 107 5 Mar Key2 98 6 Jan Key3 701 7 Feb Key3 703 8 Mar Key3 712 9</LI-CODE><P>And I would like it to look like that :</P><LI-CODE lang="markup">Month Key Value Number ------------------------------ Jan Key1 50 1 Feb Key1 57 1 Mar Key1 51 1 Jan Key2 101 2 Feb Key2 107 2 Mar Key2 98 2 Jan Key3 701 3 Feb Key3 703 3 Mar Key3 712 3</LI-CODE><P>Is it possible ? Thanks.</P> Mon, 04 Apr 2022 11:37:55 GMT https://community.splunk.com/t5/Splunk-Search/How-to-give-matching-fields-the-same-number/m-p/592190#M206132 Newser703 2022-04-04T11:37:55Z https://community.splunk.com/t5/Splunk-Search/How-to-give-matching-fields-the-same-number/m-p/592194#M206133 <LI-CODE lang="markup">| streamstats dc(Key) as Number</LI-CODE> Mon, 04 Apr 2022 11:45:03 GMT https://community.splunk.com/t5/Splunk-Search/How-to-give-matching-fields-the-same-number/m-p/592194#M206133 ITWhisperer 2022-04-04T11:45:03Z