Sideview Utils: How to create a drop-down using a lookup table with multiple values in an advanced XML dashboard?

[0waste_splunk]

Hi,

I am using sideview util to create advanced XML Dashboard. my Dashboard contains 2 pulldown/dropdown and 2 textbox.
Now,

----- 1st Pulldown/Dropdown is static Pulldown which contains A, B, C, D, E.

---

My Lookup table look like as follow:(alpha.csv)

Category1, Category2
A,Apple
B,Boy
C,Cat
C,Clown
D,Dog
E,Elephant
E,Excellent
E,Easy

---

When I select A in 1st Dropdown it will fill 2nd dropdown with Apple and so forth.

The issue here When I select C or E in 1st Dropdown, 2nd Dropdown filled up as 1 value "Cat, Clown" or "Elephant, Excellent, Easy" respectively. What I want is When I select C in 1st Dropdown, 2nd dropdown should have 2 different value of Cat, Clown so I can select Cat or Clown from 2nd dropdown.

to fill 2nd Dropdown I used PostProcess field in PullDown
$postProcess$ | lookup alpha.csv Category1 output Category2

Am I Missing anything here?

[somesoni2 · Accepted solution]

Seems like the token of first dropdown not used correctly. Could you post your dashboard code for both the dropdown?

Also, try this query for 2nd dropdown.

Assuming, token name for first dropdown is $category1$ then try this

| inputlookup alpha.csv | search Category1="$category1$" | table Category2

[0waste_splunk]

Hi somesoni2,

Thanks. It worked.

Really appreciate your time.

Thanks.