topic Re: How to match the products within the same column and the result should be matching productnumber in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-match-the-products-within-the-same-column-and-the-result/m-p/623711#M216819 <P>Out of the products, which are all the products that are not common across customers within a single division. How to find that, please</P><P>&nbsp;</P> Thu, 08 Dec 2022 12:12:55 GMT MG 2022-12-08T12:12:55Z How to match the products within the same column and the result should be matching productnumber? https://community.splunk.com/t5/Splunk-Search/How-to-match-the-products-within-the-same-column-and-the-result/m-p/623698#M216815 <P>The result should look like the table given below.Need to find the matching product number within customers and the result should be the matching product number, if not null. Can you please suggest</P> <P>&nbsp;</P> <TABLE width="521"> <TBODY> <TR> <TD width="257"><A href="https://spglobal.splunkcloud.com/en-US/app/spgi_public_search/search?q=%7Cinputlookup%20Finance_All_Division_Customer_Product_Sample_Madhuri_DND.csv%0A%7Cwhere%20Division%3D%22S%26P%20Dow%20Jones%20Indices%22%0A%7Cstats%20values(Product_number)%20as%20Product_number%20by%20Customer_name&amp;display.page.search.mode=fast&amp;dispatch.sample_ratio=1&amp;workload_pool=standard_perf&amp;earliest=-30m%40m&amp;latest=now&amp;display.page.search.tab=statistics&amp;display.general.type=statistics&amp;display.visualizations.charting.chart=column&amp;display.visualizations.trellis.enabled=0&amp;display.visualizations.charting.legend.placement=right&amp;display.visualizations.charting.axisTitleX.visibility=visible&amp;display.visualizations.charting.axisTitleY.visibility=visible&amp;display.visualizations.charting.axisTitleY2.visibility=visible&amp;display.visualizations.trellis.splitBy=Customer_name&amp;display.visualizations.trellis.size=small&amp;display.visualizations.trellis.scales.shared=0&amp;sid=1670495514.39577_9B194583-69BE-44CB-9E9E-9EBC0DA481EB" target="_blank" rel="noopener">Customer_name</A></TD> <TD width="200">Product_number</TD> <TD width="64">Result</TD> </TR> <TR> <TD width="257">Customer1</TD> <TD width="200">P1</TD> <TD>P1, P2</TD> </TR> <TR> <TD width="200">P2</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="200">P3</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="200">P4</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="200">&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="200">&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="257">Customer 2</TD> <TD width="200">P2</TD> <TD>P2</TD> </TR> <TR> <TD width="200">P5</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="200">&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="257">Customer 3</TD> <TD width="200">P3</TD> <TD>Null</TD> </TR> <TR> <TD width="200">P6</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="200">&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD width="200">&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> Thu, 08 Dec 2022 19:33:58 GMT https://community.splunk.com/t5/Splunk-Search/How-to-match-the-products-within-the-same-column-and-the-result/m-p/623698#M216815 MG 2022-12-08T19:33:58Z Re: How to match the products within the same column and the result should be matching productnumber https://community.splunk.com/t5/Splunk-Search/How-to-match-the-products-within-the-same-column-and-the-result/m-p/623707#M216818 <P>It is not clear how the result is derived from the customer name and product number. Please can you clarify?</P> Thu, 08 Dec 2022 11:26:11 GMT https://community.splunk.com/t5/Splunk-Search/How-to-match-the-products-within-the-same-column-and-the-result/m-p/623707#M216818 ITWhisperer 2022-12-08T11:26:11Z Re: How to match the products within the same column and the result should be matching productnumber https://community.splunk.com/t5/Splunk-Search/How-to-match-the-products-within-the-same-column-and-the-result/m-p/623711#M216819 <P>Out of the products, which are all the products that are not common across customers within a single division. How to find that, please</P><P>&nbsp;</P> Thu, 08 Dec 2022 12:12:55 GMT https://community.splunk.com/t5/Splunk-Search/How-to-match-the-products-within-the-same-column-and-the-result/m-p/623711#M216819 MG 2022-12-08T12:12:55Z Re: How to match the products within the same column and the result should be matching productnumber https://community.splunk.com/t5/Splunk-Search/How-to-match-the-products-within-the-same-column-and-the-result/m-p/623714#M216822 <P>Please can you clarify your data / example?</P><P>Is product number a multivalue field for each customer?</P><P>Customer_name Product_number</P><TABLE><TBODY><TR><TD>Customer 1</TD><TD><DIV class="">P1</DIV><DIV class="">P2</DIV><DIV class="">P3</DIV><DIV class="">P4</DIV></TD></TR><TR><TD>Customer 2</TD><TD><DIV class="">P2</DIV><DIV class="">P5</DIV></TD></TR><TR><TD>Customer 3</TD><TD><DIV class="">P3</DIV><DIV class="">P6</DIV></TD></TR></TBODY></TABLE><P>If so, why is the result for Customer 1 not P1, P3, P4? etc.</P> Thu, 08 Dec 2022 12:48:53 GMT https://community.splunk.com/t5/Splunk-Search/How-to-match-the-products-within-the-same-column-and-the-result/m-p/623714#M216822 ITWhisperer 2022-12-08T12:48:53Z