nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filtering data in one DS based on data from another DS

hedgehog

Hello,
 
I'm using data set DS1 when selecting a parameter MASTER. Based on that choice I need to get values for
all SLAVES from this DS1 and use it for filtering a DS2.
 
In DS2 I have only information about SLAVES and I don't have the MASTERs available.
I know how to filter the DS2 (on Prepare), but I don't know how to get the values for all SLAVES
from the DS1 and when - in the initialize script?
 
Thank you very much for your help,
Lucy

Find more posts tagged with

Comments

hedgehog

Hello,
 
maybe an example will help.
In DS1 I have columns GROUP and PART. Each GROUP has several PARTS.
In DS2 I have column PART and may other columns. There is not the column GROUP.
I can not join the DSs, because it is taking to long.
 
The user want to select parameter GROUP from DS1. I need to filter the DS2 based on
PARTS belonging to selected GROUP. At some point (before filtering the DS2) I need to load
the PARTS from DS1 so that I can use them for filtering.
And I don't know how to access the DS1 and when?
 
Thank you in advance for your help,
Lucy

CodeRookie

Lucy,
Good morning! I just finished a project that had almost the same function as what you are describing. The way I handled it was to use a drillthrough on the first report to pass the needed parameters (or filters) to a second report.
 
I'm going to attach two report designs for you to take a look at and see if they may help.

hedgehog

Hello Scott,
 
thank you very much for your reply. I don't need to drill through, I have only one report.
So, DS1 is used for parameter selection - parameter GROUP and DS2 should be filtered according to PARTS in this group.
But I find the solution

It turn to be easy at the end.
 
I created a table for DS1, and filtered it based on parameter GROUP. I add a new column to this table and placed
the DS2 there. Then I filter the DS2 using row._outer["PART"]
 
Have a nice day!
 
Lucy