topic How to get all values which belong to one value type? in Splunk Enterprise https://community.splunk.com/t5/Splunk-Enterprise/How-to-get-all-values-which-belong-to-one-value-type/m-p/597764#M12544 <P>Hi,</P><P>I have a predefined: The original object has id = <STRONG>123</STRONG>, the children object has the id = motherid + surfix, ex: <STRONG>123</STRONG>56</P><P>I have a CSV file in Lookups like this:</P><TABLE border="0" width="160" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="80" height="20">Id</TD><TD width="80">Type</TD></TR><TR><TD height="20">12312</TD><TD>adult</TD></TR><TR><TD height="20">12345</TD><TD>children</TD></TR><TR><TD height="20">12367</TD><TD>adult</TD></TR><TR><TD height="20">12398</TD><TD>adult</TD></TR><TR><TD height="20">12368</TD><TD>children</TD></TR><TR><TD height="20">123985</TD><TD>elder</TD></TR><TR><TD height="20">1239647</TD><TD>elder</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I search for all Id belong to each type of an object, ex: type = adult, or type = children belong to object id = 123</P><P>&nbsp;</P><P>Thanks in advanced!</P> Fri, 13 May 2022 12:30:51 GMT Julia1231 2022-05-13T12:30:51Z How to get all values which belong to one value type? https://community.splunk.com/t5/Splunk-Enterprise/How-to-get-all-values-which-belong-to-one-value-type/m-p/597764#M12544 <P>Hi,</P><P>I have a predefined: The original object has id = <STRONG>123</STRONG>, the children object has the id = motherid + surfix, ex: <STRONG>123</STRONG>56</P><P>I have a CSV file in Lookups like this:</P><TABLE border="0" width="160" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="80" height="20">Id</TD><TD width="80">Type</TD></TR><TR><TD height="20">12312</TD><TD>adult</TD></TR><TR><TD height="20">12345</TD><TD>children</TD></TR><TR><TD height="20">12367</TD><TD>adult</TD></TR><TR><TD height="20">12398</TD><TD>adult</TD></TR><TR><TD height="20">12368</TD><TD>children</TD></TR><TR><TD height="20">123985</TD><TD>elder</TD></TR><TR><TD height="20">1239647</TD><TD>elder</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I search for all Id belong to each type of an object, ex: type = adult, or type = children belong to object id = 123</P><P>&nbsp;</P><P>Thanks in advanced!</P> Fri, 13 May 2022 12:30:51 GMT https://community.splunk.com/t5/Splunk-Enterprise/How-to-get-all-values-which-belong-to-one-value-type/m-p/597764#M12544 Julia1231 2022-05-13T12:30:51Z