DSXchange

Need help in below topic

input data

Col1(Timestamp) Col2(timestamp)

2017-12-31 10:05:06 | 2017-12-31 10:05:06
2018-01-01 07:20:05 | 2018-01-01 07:23:05
2018-01-01 07:22:05 | 2018-01-01 07:25:05
2019-01-01 06:00:04 | 2019-01-01 06:00:05

output needed

2017-12-31 10:05:06 | 2017-12-31 10:05:06
2018-01-01 07:20:05 | 2018-01-01 07:25:05
2019-01-01 06:00:04 | 2019-01-01 06:00:05

we have to compare col1 and col2, if col1 timestamp falls between col2 for exp shown above 2 and 3 rd record need 2nd record as op

Thanks in advance..

So... you need to collapse multiple records over a single day down to a single record and min/max the timestamp? If so - what are your thoughts, what have you tried? If not - please clarify.

I don't get it. Are you comparing values across multiple records???

i using datastage transformer for saving off the values with stage variables and looping based on above..is it way of doing it?

Yes. It is a way.

I'd use an Aggregator stage if all that is required is the grouping columns and the minimum and maximum value per group.

That is a way as well.

Just make sure you group on the date and not the full timestamp.