Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

JSON or Array in a tmap

Hi

 

I have a input file that contains a start time for a booking 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 addDate.

 

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

Labels (4)
1 Reply
akumar2301
Specialist II
Specialist II

One of the way , assuming your lookup array is like
Mon,17:30
Tue,18:30
.
.
Sun 23:00

Input — tjavarow( add another col with day of week of reservation datelike mon,tue ..it can be done by format date function EEE expression) — tmap (with lookup of closing time, inner join) — output ( if duration is -1 , read add lookup closing time otherwise duration to reservation date )

Hope this would be helpfull)