Update hardcoded details if they are missing

[sbhadra]

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.

[sbhadra]

Hi Team,

Any suggestion on the same.

[gjeremy1617088143]

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

[sbhadra]

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.

[sbhadra]

Hi Team,

Any suggestion on the same

[MS5]

If you have only one store data for one execution you can do :

• put store name in a global var
• tfixedflowinput (with all days of week parametered) -> tmap (left outer join with your input data) -> output

 

But it will not work if you have many store in the same inputdataset