Validation

[ghostraider]

Hi everybody, I am extracting two columns named SAMPLE_ID and TEST from an oracle table. Now i need to do a validation based on the condition:

If SAMPLE_ID<>Previous_SAMPLEID or TEST<>PREVIOUS_TEST Then
Sequence=0 Else Sequence=Sequence+1.

Sequence will be a new column which i have to generate. Now, can you guys let me know as to how i should deal with the If statement above. Do i need to write a subroutine?

Thanks

[Krazykoolrohit]

Add Five stage variables

Code: Select all

samplVar1(definition)- If LINK.SAMPLEID = samplVAR2 then 1 else 0
samplVar2(definition)- LINK.SAMPLEID
testVar1(definition)- If LINK.TEST = testVar2 then 1 else 0
testVar2(definition) - LINK.TEST

sequence (definition) - If samplVar1 = 0 or samplVar2 = 0 then 0 else sequence+1

[narasimha]

You could also explore "RowProcCompareWithPreviousValue" routine to achieve it.

[ganesh123]

As you want to remember the past value of sequence better to write a subroutine :


Please send a test data, I want to know the column position in your file

[DSguru2B]

No routine is required in this case. This scenario can be handled perfectly and Krazykoolrohit gave a demo on that.
If your absolutely have to use a routine, then go for narasimha's suggestion. No need to re-invent the wheel.
My 2 centy!

[ganesh123]

On the lighther side, if weels have not been re-invented we would have struck with

http://patentpending.blogs.com/patent_p ... 154_pm.jpg

[DSguru2B]

Very funny ganesh123. Thats not called re-invention. Thats called enhancement.

[ganesh123]

Re-invention is alwayz done for Enhancement purpose only.

[ghostraider]

Hi all thanks much for the solution and suggestions. It is not absolutely necessary for me to use the necessary subroutine. KrazyKoolRohit's idea did work excellently.

Thanks once again :D

[DSguru2B]

Time to mark your post as 'Resolved'.