how i can display only one value using dropdown?

[rajhemant26]

Hello, everyone

I am using one CSV file to display the output. I have added the screenshot for CSV file.

[vnravikumar]

Hi

Check this and modify accordingly

<form>
  <label>Product</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="product">
      <label>Product Type</label>
      <choice value="ProductA">ProductA</choice>
      <choice value="ProductB">ProductB</choice>
    </input>
    <input type="dropdown" token="field2">
      <label>field2</label>
      <fieldForLabel>Version</fieldForLabel>
      <fieldForValue>Version</fieldForValue>
      <search>
        <query>|inputlookup RK.csv | eval date = strptime($product$,"%d/%m/%y") | where date < now() | table Version | sort - Version</query>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
    </input>
  </fieldset>
</form>

OR

If you want only the latest value

<form>
  <label>Product</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="product">
      <label>Product Type</label>
      <choice value="ProductA">ProductA</choice>
      <choice value="ProductB">ProductB</choice>
    </input>
    <input type="dropdown" token="field2">
      <label>field2</label>
      <fieldForLabel>Version</fieldForLabel>
      <fieldForValue>Version</fieldForValue>
      <search>
        <query>|inputlookup RK.csv | eval date = strptime($product$,"%d/%m/%y") | where date < now() | table Version | sort 1 - Version</query>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
    </input>
  </fieldset>
</form>