This is a sample output using stats values. Sorry, I give a wrong example. Here's the current one. from: field1 field2 field3 field4 row1 1.1.1.1 XXX alpha.splunk.com alpha row2 2.2.2.2 YYY beta.splunk.com BETA row3 3.3.3.3 ZZZ delta.splunkanswers.com delta row4 4.4.4.4 AAA abcdefgh To: field1 field2 field3 field4 row1 1.1.1.1 XXX alpha.splunk.com row2 2.2.2.2 YYY beta.splunk.com row3 3.3.3.3 ZZZ delta.splunkanswers.com row4 4.4.4.4 AAA abcdefgh So, for field4, alpha.splunk.com and alpha is just one value (multi-value), beta and beta.splunk.com is one value (multi-value), so on... I want to remove the redundant names (hostname only and host with FQDN) as long it same value (example: alpha and alpha.splunk.com)
... View more