Creating Relations between two tables in a Load Script Editor

[vidyasagar159]

Hello All,

I have two sets of tables. As per the requirement, I have created a drop-down using MetricFlag column from Table1. Let's say when user select "AUM" the reports show $1000 and vice-versa. This I have achieved but the tricky requirement is I have to create another drop down filter from Table2. This drop-down should show only the "Target DIM" values based on the selection of "MetricFlag" value.

For Example: If I select  "AUM" from the Drop Down I should see ONLY "Greater Than 500" in the second Drop Down. If I select "NetFlow" I should see ONLY "Less Than 20". 

The Question is how can I create the relation between these two tables?

Table1:

MetricFlag	Amount
AUM	1000
NetFlow	10

Table2:

TargetDIm	TargetValue
Greate Than 500	500
Less Than 20	20

Thanks,

-Vidya

[trdandamudi]

Hope I understood your question:

Table1:

MetricFlag	Amount
AUM	1000
NetFlow	10

Table2:

MetricFlag	TargetDIm	TargetValue
AUM	Greate Than 500	500
NetFlow	Less Than 20	20

I am not sure how many rows you have, but either way you can use mapping table concept and get your tables in the above layout. Hope this helps...