List Box tool to feed Filter tool

Question

Hello All,

I have

dataset 1 which has two fields Name, Vaue

dataset 2 which has id, deal_name

dataset 1 should be connected to List box tool which should be connected to a filter tool to update the selection made in the list box and filter from data set 2. I created an Analytic App which does this,but its not filtering anything.

Can you please help me out on this? Attached the sample workflow

Data set 1

Name      Value

BRIGHT  656

CHINA    658

List Box.yxwz

DanielNavarro · Answer

I have created a mock solution with the action tool and filter working properly. The only difference is that the input for the list box is a text input. Your workflow has one that is from an external list and I would refer to jrlindem for guidance on that. One way to test to make sure that the list box is pulling in the relevant information you are wanting to filter based on is by going into the test view within Interface Designer. In test view, you should see the available options to pick so that the filter can work properly. In my mock solution and within the test view, you are able to pick either BRIGHT or CHINA. If you are not able to see the data points you want to filter based off of, then more than likely the List Box tool is the culprit.

Please let me know if you are able to get it to work.

Disclaimer  - if you use the mock solution, I did not set up the Output data correctly and I was deleting in between each test run to ensure app was filtering correctly.

Solution1.yxzp

jrlindem · Answer

Looking at your workflow and reading the conversation, I see that your List Box is referencing values that come from an external source:

* C:\Users\...\Desktop\List Oct 1.xlsx

This file must be accessible from the server or it needs to be packaged with the application.  I'm guessing that it's not referenceable by your application and therefore failing to be regarded (meaning it's just filtering on the DealName tag and finding nothing that matches that).

So you'll need to ensure that External Source file is discoverable or consider hard-coding the list into your workflow or having it accessible via a database table that your gallery has access to see.

Hope that helps, -Jay

Sarath27 · Answer

I changed in the way you suggested, but still filter tool filters zero records. I know its a simple one, but I have been trying this for very long.