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