Drop or reject records from transformer based on field value

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
srinivas Guduru
Premium Member
Premium Member
Posts: 38
Joined: Sat Dec 29, 2007 9:58 am

Drop or reject records from transformer based on field value

Post by srinivas Guduru »

I would like to drop or reject the records based on the one column(filed) values (example Abs-Flag = 97 or 98 or 99)

These records should be droped or rejected from transformer stage.
Where Abs-Flag = 97 or 98 or 99

Can you please suggest me the logic with ttransformer


Thanks

Srini
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Use the "Constraints" in your transform stage to direct output down a link when the constraint condition is met.
srinivas Guduru
Premium Member
Premium Member
Posts: 38
Joined: Sat Dec 29, 2007 9:58 am

Can you give me the syntax for constraint

Post by srinivas Guduru »

ArndW wrote:Use the "Constraints" in your transform stage to direct output down a link when the constraint condition is met.
Can you please give me syntax for the constraint using Input linkname field name and values
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Code: Select all

Abs-Flag <> 97 And Abs-Flag <> 98 And Abs-Flag <> 99
You are the creator of your destiny - Swami Vivekananda
Post Reply