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