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: 37

Post Posted: Sat Jun 22, 2019 11:01 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.
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54582
Location: Sydney, Australia
Points: 295988

Post Posted: Mon Jun 01, 2020 8:23 pm Reply with quote    Back to top    

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.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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