https://community.splunk.com/t5/Splunk-Search/Joint-two-table-with-subrow/m-p/495758#M138197 <P>please provide both queries.</P> Sun, 10 May 2020 21:27:49 GMT to4kawa 2020-05-10T21:27:49Z https://community.splunk.com/t5/Splunk-Search/Joint-two-table-with-subrow/m-p/495757#M138196 <P>I' struggle with joining two following table:<BR /> Table1<BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/8880i171E2AA96DF45354/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>Table 2<BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/8881i5E303A317CE75DB2/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>The row company of table 1 contains two industry_id, which I want to joint with the second table. The result should be like this:</P> <H2>`</H2> <P>ADIDAS AG | 194677F8-7774-4685-896D-9FB45E248245 | Sshwaz</P> <H2> | 4418BACC-BF07-452C-B3A7-BACBAD469FFD | Retail</H2> <TABLE><THEAD> <TR> <TH>DEUTSCHE LUFTHANSA AG</TH> </TR> </THEAD><TBODY> </TBODY></TABLE> <P>`</P> <P>Is there anyway to get that result?</P> Sun, 10 May 2020 11:06:16 GMT https://community.splunk.com/t5/Splunk-Search/Joint-two-table-with-subrow/m-p/495757#M138196 alberttra 2020-05-10T11:06:16Z https://community.splunk.com/t5/Splunk-Search/Joint-two-table-with-subrow/m-p/495758#M138197 <P>please provide both queries.</P> Sun, 10 May 2020 21:27:49 GMT https://community.splunk.com/t5/Splunk-Search/Joint-two-table-with-subrow/m-p/495758#M138197 to4kawa 2020-05-10T21:27:49Z