Skip to Content

Between dates

Hi

I have 2 tables in a webi report.

In table 1 I have a start date and the manager name, in some cases the managers name will be blank.There is also a reference number for a job position.

In table 2 I have the reference number of a job position and a start date and end date.

I want to be able to create a variable that will show me either the managers name or blank if there is not one, for the job reference, based on the date range in table 2 (start date/end date), it should look at table 1 and determine from the start date in table 1 who the manager was for that job reference number.

Can anyone recommend how I can achieve this.

many thanks

Will

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 14, 2017 at 02:13 PM

    Hi,

    follow Jothi 's explanation. merge the two tables on Job Reference,

    then

    1. create variable v_manager as detail of the merged dimension Job Reference
    2. create variable v_mandager_date as detail of the merged dimension Job Reference
    3. you van now create table whith al dimensions (using the variables and the merged dimensions instead of table 1 dimensions)
    4. create variable v_check where you check the dates and show v_manager if it is required.

    Can't grasp your data, so it could be the other way around, where you create detail objects of the second table.

    But you got the idea

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded