https://community.splunk.com/t5/Dashboards-Visualizations/How-to-join-rows-to-compare-values/m-p/646771#M52879 <P>maybe this wil help?:</P><LI-CODE lang="markup">&lt;form version="1.1"&gt; &lt;label&gt;tmp-pr-tags&lt;/label&gt; &lt;fieldset&gt; &lt;input type="dropdown" token="dropdown_tok" searchWhenChanged="true"&gt; &lt;label&gt;Selecteer een PR_Tag:&lt;/label&gt; &lt;choice value="*"&gt;PR_Tags...&lt;/choice&gt; &lt;search&gt; &lt;query&gt; &lt;![CDATA[ index=main sourcetype=csv source=result_test.csv | table PR_Tags, PR_ID | eval PR_Tags=split(PR_Tags,",") | mvexpand PR_Tags | dedup PR_Tags PR_ID ]]&gt; &lt;/query&gt; &lt;earliest&gt;0&lt;/earliest&gt; &lt;latest&gt;&lt;/latest&gt; &lt;/search&gt; &lt;fieldForLabel&gt;PR_Tags&lt;/fieldForLabel&gt; &lt;fieldForValue&gt;PR_Tags&lt;/fieldForValue&gt; &lt;/input&gt; &lt;/fieldset&gt; &lt;row&gt; &lt;panel&gt; &lt;title&gt;PR_Tags&lt;/title&gt; &lt;table&gt; &lt;search&gt; &lt;query&gt; index=main sourcetype=csv source=result_test.csv | where PR_Tags="$dropdown_tok$" | table PR_Tags, PR_ID | eval PR_Tags=split(PR_Tags,",") | mvexpand PR_Tags | dedup PR_Tags PR_ID &lt;/query&gt; &lt;/search&gt; &lt;option name="count"&gt;50&lt;/option&gt; &lt;option name="drilldown"&gt;none&lt;/option&gt; &lt;option name="rowNumbers"&gt;true&lt;/option&gt; &lt;/table&gt; &lt;/panel&gt; &lt;/row&gt; &lt;/form&gt;</LI-CODE> Tue, 13 Jun 2023 07:42:41 GMT rrovers 2023-06-13T07:42:41Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-join-rows-to-compare-values/m-p/646748#M52875 <P>Hello.</P><P>I have these two rows (PR_Tags and PR_ID). Need to return the PR_ID's that are matching the PR_Tags when I select in a Dropdown filter (Like if I select the line 1row 1, return the PR_ID's that matches this PR_Tag selected)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KalebeRS_0-1686635236994.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/25802iC27346246EB82879/image-size/medium?v=v2&amp;px=400" role="button" title="KalebeRS_0-1686635236994.png" alt="KalebeRS_0-1686635236994.png" /></span></P><P>How can I do that?</P><P>&nbsp;</P><LI-CODE lang="markup">index= host= sourcetype=csv source=........\\resul_test.csv | table PR_Tags, PR_ID | eval PR_Tags=split(PR_Tags,",") | mvexpand PR_Tags | dedup PR_Tags PR_ID</LI-CODE><P>&nbsp;</P> Tue, 13 Jun 2023 05:49:37 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-join-rows-to-compare-values/m-p/646748#M52875 KalebeRS 2023-06-13T05:49:37Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-join-rows-to-compare-values/m-p/646771#M52879 <P>maybe this wil help?:</P><LI-CODE lang="markup">&lt;form version="1.1"&gt; &lt;label&gt;tmp-pr-tags&lt;/label&gt; &lt;fieldset&gt; &lt;input type="dropdown" token="dropdown_tok" searchWhenChanged="true"&gt; &lt;label&gt;Selecteer een PR_Tag:&lt;/label&gt; &lt;choice value="*"&gt;PR_Tags...&lt;/choice&gt; &lt;search&gt; &lt;query&gt; &lt;![CDATA[ index=main sourcetype=csv source=result_test.csv | table PR_Tags, PR_ID | eval PR_Tags=split(PR_Tags,",") | mvexpand PR_Tags | dedup PR_Tags PR_ID ]]&gt; &lt;/query&gt; &lt;earliest&gt;0&lt;/earliest&gt; &lt;latest&gt;&lt;/latest&gt; &lt;/search&gt; &lt;fieldForLabel&gt;PR_Tags&lt;/fieldForLabel&gt; &lt;fieldForValue&gt;PR_Tags&lt;/fieldForValue&gt; &lt;/input&gt; &lt;/fieldset&gt; &lt;row&gt; &lt;panel&gt; &lt;title&gt;PR_Tags&lt;/title&gt; &lt;table&gt; &lt;search&gt; &lt;query&gt; index=main sourcetype=csv source=result_test.csv | where PR_Tags="$dropdown_tok$" | table PR_Tags, PR_ID | eval PR_Tags=split(PR_Tags,",") | mvexpand PR_Tags | dedup PR_Tags PR_ID &lt;/query&gt; &lt;/search&gt; &lt;option name="count"&gt;50&lt;/option&gt; &lt;option name="drilldown"&gt;none&lt;/option&gt; &lt;option name="rowNumbers"&gt;true&lt;/option&gt; &lt;/table&gt; &lt;/panel&gt; &lt;/row&gt; &lt;/form&gt;</LI-CODE> Tue, 13 Jun 2023 07:42:41 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-join-rows-to-compare-values/m-p/646771#M52879 rrovers 2023-06-13T07:42:41Z