topic Remove duplicate columns - column which have single unique value in Splunk Search https://community.splunk.com/t5/Splunk-Search/Remove-duplicate-columns-column-which-have-single-unique-value/m-p/675798#M231189 <P>Hi,&nbsp;</P><P>I want to get rid of columns which have single unique value. There could be multiple columns showing this behavior.&nbsp;</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%" height="24px">Test</TD><TD width="25%" height="24px">Value1</TD><TD width="25%" height="24px">Value2</TD><TD width="12.5%" height="24px">Value3</TD><TD width="12.5%">Value4</TD></TR><TR><TD width="25%" height="24px">Test1</TD><TD width="25%" height="24px">2</TD><TD width="25%" height="24px">b</TD><TD width="12.5%" height="24px">a</TD><TD width="12.5%">7</TD></TR><TR><TD width="25%" height="24px">Test2</TD><TD width="25%" height="24px">1</TD><TD width="25%" height="24px">c</TD><TD width="12.5%" height="24px">a</TD><TD width="12.5%">7</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to get rid of columns "Value3" and "Value4"&nbsp;since they have only one unique value across.</P><P>&nbsp;</P><P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/225168">@ITWhisperer</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/206061">@scelikok</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/231884">@PickleRick</a>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 29 Jan 2024 17:15:03 GMT bhavesh0124 2024-01-29T17:15:03Z Remove duplicate columns - column which have single unique value https://community.splunk.com/t5/Splunk-Search/Remove-duplicate-columns-column-which-have-single-unique-value/m-p/675798#M231189 <P>Hi,&nbsp;</P><P>I want to get rid of columns which have single unique value. There could be multiple columns showing this behavior.&nbsp;</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%" height="24px">Test</TD><TD width="25%" height="24px">Value1</TD><TD width="25%" height="24px">Value2</TD><TD width="12.5%" height="24px">Value3</TD><TD width="12.5%">Value4</TD></TR><TR><TD width="25%" height="24px">Test1</TD><TD width="25%" height="24px">2</TD><TD width="25%" height="24px">b</TD><TD width="12.5%" height="24px">a</TD><TD width="12.5%">7</TD></TR><TR><TD width="25%" height="24px">Test2</TD><TD width="25%" height="24px">1</TD><TD width="25%" height="24px">c</TD><TD width="12.5%" height="24px">a</TD><TD width="12.5%">7</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to get rid of columns "Value3" and "Value4"&nbsp;since they have only one unique value across.</P><P>&nbsp;</P><P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/225168">@ITWhisperer</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/206061">@scelikok</a>&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/231884">@PickleRick</a>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 29 Jan 2024 17:15:03 GMT https://community.splunk.com/t5/Splunk-Search/Remove-duplicate-columns-column-which-have-single-unique-value/m-p/675798#M231189 bhavesh0124 2024-01-29T17:15:03Z Re: Remove duplicate columns - column which have single unique value https://community.splunk.com/t5/Splunk-Search/Remove-duplicate-columns-column-which-have-single-unique-value/m-p/675804#M231192 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/259886">@bhavesh0124</a>,</P><P>sorry bu it isn't possible: Splunk isn't Excel in which you can collapse two cells in one.</P><P>Ciao.</P><P>Giuseppe</P> Mon, 29 Jan 2024 17:31:00 GMT https://community.splunk.com/t5/Splunk-Search/Remove-duplicate-columns-column-which-have-single-unique-value/m-p/675804#M231192 gcusello 2024-01-29T17:31:00Z Re: Remove duplicate columns - column which have single unique value https://community.splunk.com/t5/Splunk-Search/Remove-duplicate-columns-column-which-have-single-unique-value/m-p/675808#M231194 <P>Depending on the size of your data set, you could try something like this</P><LI-CODE lang="markup">| appendpipe [| stats values(*) as * | eval Test="ALL"] | transpose 0 column_name=name header_field=Test | where mvcount(ALL) &gt; 1 | fields - ALL | transpose 0 column_name=Test header_field=name</LI-CODE> Mon, 29 Jan 2024 17:45:58 GMT https://community.splunk.com/t5/Splunk-Search/Remove-duplicate-columns-column-which-have-single-unique-value/m-p/675808#M231194 ITWhisperer 2024-01-29T17:45:58Z Re: Remove duplicate columns - column which have single unique value https://community.splunk.com/t5/Splunk-Search/Remove-duplicate-columns-column-which-have-single-unique-value/m-p/675821#M231202 <P>Works perfectly, thanks</P> Mon, 29 Jan 2024 19:51:15 GMT https://community.splunk.com/t5/Splunk-Search/Remove-duplicate-columns-column-which-have-single-unique-value/m-p/675821#M231202 bhavesh0124 2024-01-29T19:51:15Z