How to get the records count by the datastage operator?
Posted: Wed May 27, 2015 9:23 am
Hi guys,
I have a requirement of filter the records by some conditions and check the recods count.
For example , I want to get the records which the conditions are column1 = 0 and column2 <>1, and the records count should more than 100.
I can use the filter operator to get the records with the conditions, but how to check whether the records count is more than 100?
if all the conditions are equal(=), i think i can use the group operator to get the countField, and check it . But if the conditions are not equal(eg:>, <, >=, <=, <>...), how to get the records count by the operator?
Which operator can get the records count from the dataset?
Any help please!
Thanks!
Johnny
I have a requirement of filter the records by some conditions and check the recods count.
For example , I want to get the records which the conditions are column1 = 0 and column2 <>1, and the records count should more than 100.
I can use the filter operator to get the records with the conditions, but how to check whether the records count is more than 100?
if all the conditions are equal(=), i think i can use the group operator to get the countField, and check it . But if the conditions are not equal(eg:>, <, >=, <=, <>...), how to get the records count by the operator?
Which operator can get the records count from the dataset?
Any help please!
Thanks!
Johnny