Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.