JSON or Array in a tmap

Anonymous — Thu, 28 Feb 2019 19:41:42 GMT

I have a input file that contains a start time for a booking (yyyy-MM-dd) and a duration (xx minutes where xx is numeric). I want to work out the end time for the booking based on these 2 parameters which is easy by using

TalendDate.addDate(Var.booking_datetime,Var.duration,"mm")

However, the duration sometimes contains -1 which signifies a the booking runs until closing time for a restaurant.

I have a list of closing times for the venue by day of the week which are sometimes different and so instead of the addDate, where duration is -1 I then want to pull in the closing time and join that to the booking start time before converting to a date. Again quite easy...

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",(StringHandling.LEFT(row4.booking_date,10) + " " + Var.closing_time))

However, I'd ideally like to be able to read lookup table containing a list of all closing times held in one column either as an array or a JSON string, then depending on the day of the week which I can work out, set the correct closing time for the venue.

I'm currently doing a straight lookup to a table containing the closing times but have set one per venue. Clearly a challenge but hopefully someone has a solution....

Thanks

Dave

Re: JSON or Array in a tmap

navds — Fri, 01 Mar 2019 12:32:08 GMT

Why don't you just delegate this operation to a routine ?

topic Re: JSON or Array in a tmap in Talend Studio

JSON or Array in a tmap

Re: JSON or Array in a tmap