Multiple Date Fiels

[ym]

I have the following code:

Order:

%ID,

Product, 

Quantity,

DateOrder,

DateBooking

FROM ..

OrderCalendar:

LOAD

num([DateOrder]) as [%DateOrder],

Year([DateOrder) AS Year.DateOrder,

RESIDENT Order;

BookingCalendar:

num([DateBooking]) as [%DateBooking],

Year([DateBooking) AS Year.DateBooking,

RESIDENT Order;

Now, I would like to add a table that specifiy the DateTyp (Type = Order or Booking). 

How can I do this?

[PrashantSangle]

create static flag for DateType

like

OrderCalendar:

LOAD

num([DateOrder]) as [%DateOrder],

Year([DateOrder) AS Year.DateOrder,

'Order' as DateType

RESIDENT Order;

BookingCalendar:

num([DateBooking]) as [%DateBooking],

Year([DateBooking) AS Year.DateBooking,

'Booking' as DateType

RESIDENT Order;

[sidhiq91]

@ym  as @PrashantSangle  mentioned you can create the static flag and if required you can concatenate both the tables:

OrderCalendar:

LOAD

num([DateOrder]) as [%DateOrder],

Year([DateOrder) AS Year.DateOrder,

'Order' as DateType

RESIDENT Order;

Concatenate(OrderCalendar)

BookingCalendar:

num([DateBooking]) as [%DateBooking],

Year([DateBooking) AS Year.DateBooking,

'Booking' as DateType

RESIDENT Order;

[ym]

@sidhiq91 This gives a synthetic key. (DateOrder/DateBooking). How can I solve this?

 

[sidhiq91]

@ym  I dont see any common fields between the tables. Could you please provide screen shot of the Synthetic table and keys?

[ym]

The problem is that in my Order Table I have also 

%DateOrder and %DateBooking.