Match on 2 values?

556 views Asked by At

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

1

There are 1 answers

0
Emma van de Vreugde On

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'.