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
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
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.
opdas wrote: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
[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).