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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
j_
Contributor
Contributor

Check Last business day logic

Hi ,

Am converting a source code into a talend pipeline.

I need to know how we can fetch the last business day in talend..Excluding the weekends ..As of now we no need to consider the holiday list

Labels (2)
2 Replies
Anonymous
Not applicable

This functionality is not provided out of the box, but you can make use of a Python Processor in your Pipeline to calculate this date. Use a Python Processor like this.....

https://help.talend.com/r/en-US/Cloud/pipeline-designer-processors-guide/performing-multiple-operations-on-customer-records-using-python

 

To calculate your required logic in Python, you will need to work this out yourself or find an example online representing the logic you need. I quickly found this....

https://stackoverflow.com/questions/2224742/most-recent-previous-business-day-in-python

 

Not sure if that is exactly what you need, but you could give it a try.

Antonio69
Contributor
Contributor

Select the cell you will return the previous working day, enter formula =WORKDAY(TODAY(),-1,F2:F4) into the Formula Bar and press the Enter key.

prepaidgiftbalance