DSXchange

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.

Moderator: please move this post to the parallel forum

This looks like it would be easily managed using looping within a Transformer stage. The exit condition from the loop would be that the test date has reached the current date.

The documentation on looping shows examples of building a delimited string. The rest is straightforward date manipulation (plus converting dates to string to get the required format).

If you want more specific help, please post what you have tried, the result you obtained from it, and any other pertinent information.