I want the output of dates from particular range in a specific format
date1: 2019-06-18(from Table) date2: 2019-06-22(systemDate)
Output will be:
2019-06-19,2019-06-20|2019-06-20,2019-06-21
Date 1 will be fetched from the table. Once we get the dates, I need to use this date in processing stage and will compare it with date2 i.e current system date. After comparision ,I need the o/p as above. I am having trouble to get the o/p in that format 2019-06-19,2019-06-20|2019-06-20,2019-06-21( in same column if possible, otherwise I will combine the column to one).
i was trying to Use while loop in Transformer stage.
Print date in particular range in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Sat Jun 22, 2019 10:50 am
- Location: Pune