Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I can have 1 filed that year : 2013,2014,2015 .
One employee is working in 2013,2014,2015
If i can select 2013 from the list box 2013 data and as well as association is nothing but if we can have same employee in 2014 that should also display.
Regards,
Sonysree
May I ask you to provide target table ? If you select only year 2013 but in table you have Employees list then association should be worked correctly
Please try:
Source:
LOAD * INLINE [
EMP, Year, SAL
101, 2013, 10k
102, 2013, 10k
103, 2013, 10k
104, 2013, 10k
105, 2013, 10k
101, 2014, 20k
103, 2014, 20k
105, 2014, 15k
106, 2014, 10k
107, 2014, 10k
102, 2015, 25k
103, 2015, 30k
106, 2015, 20k
107, 2015, 20k
108, 2015, 10k
109, 2015, 10k
];
EMP_Year:
Load distinct
EMP,
Year as [Base Year]
Resident Source;
In dashboard use [Base Year] for selecting.