I have person data
Employee ID || Length of Service || Age
and a Payment table Length of Service || Age || Paid weeks
I want to return Paid weeks for each of the person data. How would i go about this?
Thanks
I have person data
Employee ID || Length of Service || Age
and a Payment table Length of Service || Age || Paid weeks
I want to return Paid weeks for each of the person data. How would i go about this?
Thanks
The easiest way to go is to join those tables on universe level.
Alternatively you can load the two tables with two queries, and merge 'Length of Service' and 'Age'. This can be done by selecting both values, and right-click 'Merge'. Now you should be able to create a table where all four different columns are shown.
In case you are unable to create this table, you could make a variable containing the information of 'Length of Service' and 'Age', and make a detail of 'Paid weeks'.