Logic for finding sequence Gap

[opdas]

Hi,
I have this situation where I need to find the gaps in the sequence and write all the gap in a file.


Source is like

Code: Select all

Col1     Col2
A            1
A            3
A            4
B            2
B            5
B            7

The target would be:

Code: Select all

Col1      Col2
A            2
B            3
B            4
B            6

I have to take into account the Max and Min value in Col2 and find sequence gaps for each unique entry for Col1.

Any idea is appreciated.

Regards
Om

[balajisr]

Sort by Col1, Col2 use stage variables to find the gap in the sequence and write to the target.

[DSguru2B]

Yes, a group change dance is required that can be accomplished via stage variables. THis has been discussed here a lot. Make the search engine your best friend

[kumar_s]

How many records will be there in the gap?
If the number of record in the gap is less, say 1 or 2 or 3 it ok, else you need to have that many stage variable to hold the values to compare and give as output.
For that case, you can build you own custome stages or routien to have the looping funtion in it.

[opdas]

How can I compare current record with previous record in stage variable? Can stage variable store previous record value or it is reset for every new record?

I tried searching but couldnt get to the right topic ...If any one has the link or keyword to search would be of great help.

[dwblore]

How can I compare current record with previous record in stage variable? Can stage variable store previous record value or it is reset for every new record?

I tried searching but couldnt get to the right topic ...If any one has the link or keyword to search would be of great help.

Life of the stage variable is the stage itself ie it lives until the entire recordset is processed.

Have Two Stg Varaibles
Old
New

Where Old=New
and New is populated with the desired column

[mani_dwbi]

[quote="opdas"]How can I compare current record with previous record in stage variable? Can stage variable store previous record value or it is reset for every new record?

I tried searching but couldnt get to the right topic ...If any one has the link or keyword to search would be of great help.[/quote]

Hello OPD,
The best link what i think tht, please look into Duplicate CDR check JOb(for intec).

[kumar_s]

As mentioned have two stage variable.

Initial declaration
Old = ''
New = ''

Stage variable derivation
Old = New
New = Input Column.


If Old = New Then {logic for duplicate} else {logic for new}

[opdas]

Kumar:
Thanks a lot , its working now, I should have got this before

Mani:
Thanks for the reply...... I'll definetly search your Intec Jobs