topic Re: Cascading Dynamic dropdowns with CSV data in Dashboards & Visualizations

How to achieve cascading dynamic drop downs with CSV data?

ramana4u — Thu, 23 Jun 2022 19:03:49 GMT

Dear Community,

How do I display values from second dropdown values based on first dropdown value.

| inputlookup regions_instances.csv | fields region region_value

| inputlookup regions_instances.csv | search region=$site$ | fields instance instance_value

Re: Cascading Dynamic dropdowns with CSV data

gcusello — Thu, 23 Jun 2022 06:47:03 GMT

Hi @ramana4u,

the approach you followed is correct, what's your issue or doubt?

Ciao.

Giuseppe

Re: Cascading Dynamic dropdowns with CSV data

ramana4u — Thu, 23 Jun 2022 08:40:57 GMT

Thanks for looking into this.

First dropdown is ok. No values shown in the second dropdown.

Re: Cascading Dynamic dropdowns with CSV data

gcusello — Thu, 23 Jun 2022 08:47:24 GMT

Hi @ramana4u,

you should check if the fields in the second lookup is the same of the first and that the value from the first is present in teh second.

Then you don't need to use where, you could use where in the inputlookup command, but thisisn't the issue.

| inputlookup regions_instances.csv WHERE region=$site$ | fields instance instance_value

could you share the full code on both inputs?

Are you using Dashboard Classic or Dashboard Studio?

Ciao.

Giuseppe

Re: Cascading Dynamic dropdowns with CSV data

ramana4u — Thu, 23 Jun 2022 09:21:57 GMT

Hi @gcusello

// Here the full code

<fieldset submitButton="false">
<input type="dropdown" token="dccsite" searchWhenChanged="true">
<label>Choose Site</label>
<fieldForLabel>region</fieldForLabel>
<fieldForValue>region_value</fieldForValue>
<search>
<query>| inputlookup regions_instances.csv | fields region region_value | dedup region region_value</query>
</search>
<default>express:dcceu:applog</default>
<initialValue>express:dcceu:applog</initialValue>
</input>
<input type="dropdown" token="dccinstance" searchWhenChanged="true">
<label>Choose Instance</label>
<fieldForLabel>instance</fieldForLabel>
<fieldForValue>instance_value</fieldForValue>
<search>
<query>|inputlookup regions_instances.csv | WHERE region=$dccsite$ | fields region region_value instance instance_value</query>
</search>
<default>/appl/dcc/dcceuexp/applogs/*</default>
<initialValue>/appl/dcc/dcceuexp/applogs/*</initialValue>
</input>
</fieldset>

// regions_instances.csv

region,region_value,instance,instance_value
APEM,express:dcc:applog,Import,/appl/dcc/dccadm/applogs/*
APEM,express:dcc:applog,Export,/appl/dcc/dccexp/applogs/*
EU,express:dcceu:applog,Import,/appl/dcc/dcceu/applogs/*
EU,express:dcceu:applog,Export,/appl/dcc/dcceuexp/applogs/*
Trans,express:dcc:applog*,Import,/appl/dcc/dcceu/dcc2/applogs/*
Trans,express:dcc:applog*,Export,/appl/dcc/dcceuexp/dcc2/applogs/*
US,*express:dcc:applog,Import,/appl/dcc/dccus/applogs/*
US,*express:dcc:applog,Export,/appl/dcc/dccusexp/applogs/*

Re: Cascading Dynamic dropdowns with CSV data

gcusello — Thu, 23 Jun 2022 09:40:08 GMT

Hi @ramana4u,

at first try to add quotes to the second input search:

| inputlookup regions_instances.csv | WHERE region="$dccsite$"

then please check if there a mistake between region and region_value maybe you have to use for the filter in the second input again region_value.

If it doesn'ìt run again try to add some asterisk at the beginning and the end of the condition.

| inputlookup regions_instances.csv | WHERE region="*$dccsite$*"

Ciao.

Giuseppe