Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Help with joining 3rd table

Please could you assist with table join:

FACT

Budget:
LOAD 
     [Position ID],
     [Cost Centre],
     Budget as Amount,
     'Budget' as Type,
     'Budgeted'as [Wage Type Text],
      Date,
      [Position ID]&[Cost Centre] as PositionKey
FROM
Table1, Source1
 
JOIN
Actuals:
LOAD [Cost Center] as [Cost Centre],
    Employee,
     Name1, 
     [Wage Type Text],
     [Posting Date] as "Date", 
     Amount,
     'Actuals' as Type,
     Position as [Position ID],
     Position&[Cost Center] as PositionKey
FROM
Table2, Source1
 
I need to join this table to create a single Fact Table  but only have  'Employee' and data for 1 month as the table is overwritten daily
 
LOAD Employee,
     Date,
     Annual_Balance_NoBooking,
     Daily_Hours,
     AL_Liability as Amount, 
     'Leave Balance' as Type,
     'Leave Balance'as [Wage Type Text]
     FTE
FROMSource 3
1 Reply
Highlighted
Partner
Partner

Re: Help with joining 3rd table

What about  joining the  3rd tables you did with no 2?  

Load ... From Table1;

Join Load ... From Table2;

Join Load ... From Table3;

If it is not possible then please explain what issue you are facing by doing so.

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes