Hi Team,
I have show today date data into yesterday date.Can you please help me on this and My data like this
LOAD * INLINE [
DATE, TYPE , NUMBER ,CODE,SALES
29-09-2016, BE, 3337, W7011, 50
29-09-2016, BE, 3338, W7011, 50
29-09-2016, BE, 3337, W7022, 50
29-09-2016, BE, 3338, W7022, 50
29-09-2016, BE, 3339, W7022, 0
30-09-2016, BE, 3337, W7011 70
30-09-2016, BE, 3338, W7011 70
30-09-2016, BE, 3337, W7022, 60
30-09-2016, BE, 3338, W7022, 70
30-09-2016, BE, 3339, W7022, 0
];
OUTPUT should be below:-
DATE | TYPE | NUMBER | CODE | SALES | CalculatedSales |
29-09-2016 | BE | 3337 | W7011 | 50 | 70 |
29-09-2016 | BE | 3338 | W7011 | 50 | 70 |
29-09-2016 | BE | 3337 | W7022 | 50 | 60 |
29-09-2016 | BE | 3338 | W7022 | 50 | 70 |
29-09-2016 | BE | 3339 | W7022 | 0 | 0 |
30-09-2016 | BE | 3337 | W7011 | 70 | 0 |
30-09-2016 | BE | 3338 | W7011 | 70 | 0 |
30-09-2016 | BE | 3337 | W7022 | 60 | 0 |
30-09-2016 | BE | 3338 | W7022 | 70 | 0 |
30-09-2016 | BE | 3339 | W7022 | 0 | 0 |
Regards
Mahesh