DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
shivam5483
Participant



Joined: 22 Jun 2019
Posts: 3
Location: Pune
Points: 36

Post Posted: Sat Jun 22, 2019 11:12 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
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.
UCDI



Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 373

Points: 3853

Post Posted: Sun Jun 23, 2019 10:05 am Reply with quote    Back to top    

transformer loops are really for splitting 1 record into multiples.

what I think you might want here would be a row-generator, and a stage variable. The stage variable would increment the date each time, and the row generator would be your loop counter of sorts...
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours