topic Update hardcoded details if they are missing in Talend Studio

Update hardcoded details if they are missing

sbhadra — Sat, 16 Nov 2024 00:17:37 GMT

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.

Re: Update hardcoded details if they are missing

sbhadra — Thu, 08 Apr 2021 06:11:48 GMT

Hi Team,

Any suggestion on the same.

Re: Update hardcoded details if they are missing

gjeremy1617088143 — Thu, 08 Apr 2021 13:04:19 GMT

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

Re: Update hardcoded details if they are missing

sbhadra — Thu, 08 Apr 2021 14:40:42 GMT

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.

Re: Update hardcoded details if they are missing

sbhadra — Fri, 09 Apr 2021 06:16:54 GMT

Hi Team,

Any suggestion on the same

Re: Update hardcoded details if they are missing

MS5 — Fri, 09 Apr 2021 08:14:27 GMT

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