looping

[talsahota]

Hi all,

i have a file/table that holds 2columns OldPolicy,NewPolicy
eg:
OldPolid , NewPolid
AA , AB
AB , AC
AC , AD

BA , BB
BB , BC

AA became AB,AB became AC, AC became AD.The net result is that AA became AD and similarly BA became BC . I need to reflect this as:
OldPolid , NewPolid
AA , AD
BA , BC

Is it best to do this using stage variables.I would be grateful for any suggestions.

[raju_chvr]

Did u give it a try with stage variables and RowProcGetPreviousValue() ?

I think that should work. In the constraints you should have a condition

RowProcGetPreviousValue(NewPolid) <> OldPolid

to write into output.

IHTH

[talsahota]

Did u give it a try with stage variables and RowProcGetPreviousValue() ?

I think that should work. In the constraints you should have a condition

RowProcGetPreviousValue(NewPolid) <> OldPolid

to write into output.

IHTH

This didnt work, any ideas why or other methods, thanks in advance

[ogmios]

If the input data is not too big the easiest would be to write a small BASIC DataStage job to cover your required functionality.

Ogmios

[raju_chvr]

Can you post the cariables and their derivation you are using ? for this ..

I will talk a look into it.

[kduke]

Use stage variables. It is easier to understand. Do a search. This has been covered in viewtopic.php?t=84848

[ray.wurlod]

Can you do something like the following:

Code: Select all

SELECT SUBSTR(OldID,1,1) AS FirstChar, MIN(OldID), MAX(NewID)
 FROM tablename
 GROUP BY FirstChar;