DSXchange

I have a requirement. I need to exclude the ranges and values like below in datastage.
4-10
25-30
80-300
00
null

Any suggestions would be appreciated.


Thanks

Exclude them from what? What are you trying to accomplish?

Try Using the reject links in LOOKUP, MERGE stage

I have values coming as above in three different columns.
condition is something like
column 1 column 2 column 3.
4 26 85 ------------>reject
00 4 null -------------->reject
3 26 85 --------------->pass


If any of those values mentioned in the actual post satisfy the above condition i should reject them.

Note: There is an 'AND' condition between the three columns.


Thanks,

Check the values directly in constraint part of the transformer.
Put the condition like

column1 < 4 and column1 > 10

and the same for other ranges to check and reject the records based on the values return.

Regards,
Vishal

This can be also acheived using Filter Stage. Not sure if conditions on multiple columns can be placed in the single filter stage. If not supported,you need to use 3 filter stages.

Regards
Ulhas

The filter stage is probably not the best choice for this type of requirement. The "Filter" stage evaluates the expression at runtime for every input row. Because the Transform is compiled it will always be faster than a Filter stage.

Also, use of Filter stage should be limited to instances where the entire filter expression must be parameterized at runtime.

Thanks for your inputs.
Sorry i have posted the actual requirement here in this link below.

viewtopic.php?t=140904

You're running two posts on the same topic and problem? That is frowned upon here.

It was vague , so i had to repost.

No, it was vague so you had to re-clarify. And that should have happened here.

Sorry My fault. Will keep this in mind next time.