All Apps and Add-ons

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

0waste_splunk
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?

1 Solution

somesoni2
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

somesoni2
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

0waste_splunk
Communicator

Hi somesoni2,

Thanks. It worked.

Really appreciate your time.

Thanks.

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...