All Apps and Add-ons
Highlighted

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

Communicator

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?

Highlighted

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

SplunkTrust
SplunkTrust

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

View solution in original post

Highlighted

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

Communicator

Hi somesoni2,

Thanks. It worked.

Really appreciate your time.

Thanks.

0 Karma