Hallo dear QV users..
i have one or two question to ask.
I have a master table, and a concatenated table for transaction table.
Master Table field :
[Entry ID] | ID | MsDate | Quantity | Type |
MS-1 | 1 | 03/31/13 12:02 PM | 192 | MS1 |
MS-2 | 2 | 03/31/13 05:53 PM | 792 | MS1 |
MS-3 | 3 | 04/30/13 08:12 AM | 0 | MS1 |
MS-4 | 4 | 04/30/13 08:12 AM | 84 | MS1 |
MS-5 | 5 | 04/30/13 08:12 AM | 336 | MS1 |
Transaction Table Field :
[Entry ID] | TransType | Date | Month | Year | MonthYear |
MS-1 | MS Tes | | 4 | 2014 | Apr-2013 |
MS-2 | MS Tes | 04/30/13 12:02 PM | 4 | 2014 | Apr-2013 |
MS-3 | MS | 04/30/13 08:12 AM | 4 | 2014 | Apr-2013 |
MS-4 | MS | 04/30/13 08:12 AM | 4 | 2014 | Apr-2013 |
MS-5 | MS | 04/30/13 08:12 AM | 4 | 2014 | Apr-2013 |
Concanate script :
Concatenate(Transaction)
LOAD
[Entry ID],
'MS Tes' as Transtype,
MsDate as Date,
DATE#(month(MsDate)& '-' & year(MsDate), 'MMM-YYYY') AS MonthYear,
MONTH(MsDate) as Month,
YEAR(MsDate) as Year
resident MPRODPLAN;
I've tried without concatenate function, and there's nothing wrong.
But when i use concatenate, missdate are appears.
My question is :
Why date for MS-1 and MS-2 in transaction table are different?
And how to fix this?
Many thx before