Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am pulling some store related data where in the store remains open on certain days and closed on certain days.
Below are the things getting pulled from the database
StoreName OpeningTime ClosingTime daysopen
X 10:00 AM 7:00 PM Monday
X 10:00 AM 7:00 PM Wednesday
X 10:00 AM 7:00 PM Saturday
X 10:00 AM 7:00 PM Friday
And the store is closed for rest of the three days where the opening time and closing time both needs to be updated as 12:00 AM . Pleased suggest how to proceed in such a scenario.
Hi Team,
Any suggestion on the same.
Hi, could you be more precise please. Input, transformation desired output etc.
If you want to schedule your batch use the windows task scheduler.
Send me Love and Kudos
The input would be like getting some store related information where in the store may be closed on someday and open on someday of the week.
StoreName OpeningTime ClosingTime daysopen
X 10:00 AM 7:00 PM Monday
X 10:00 AM 7:00 PM Wednesday
X 10:00 AM 7:00 PM Saturday
X 10:00 AM 7:00 PM Friday
Over here the store name is X and we have the opening time and the closing time and also the days when the store would be open. In this case the store is open on Monday , Wednesday, Friday and Saturday and closed on rest of the days. The days on which the store is closed the opening and closing time should be 12 AM
StoreName OpeningTime ClosingTime daysopen
X 12:00 AM 12:00 AM Sunday
X 12:00 AM 12:00 AM Thursday
X 12:00 AM 12:00 AM Tuesday
Please suggest on the same.
Hi Team,
Any suggestion on the same
If you have only one store data for one execution you can do :
But it will not work if you have many store in the same inputdataset