I have a seq file with the input colums of ZIP_END_DT_DEF,MBR_ADR_ROW_EFF_DT,ZIP_EFF_DT_DEF,MBR_ADR_ROW_END_DT.
while i am checking the condition (ZIP_END_DT_DEF>=MBR_ADR_ROW_EFF_DT) And (ZIP_EFF_DT_DEF<=MBR_ADR_ROW_END_DT). i am getting 119925 output rows. but my expected output rows are 119813.
since i am getting 112 rows extra and within this 24 rows are not matching(satisfying) condition given above.
All columns are date datatype and length is 10.
problem in filter condition---
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Mon Dec 11, 2006 10:57 am
- Location: Pune
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How many input rows are there? Create a second output from your Filter or Transformer stage that handles the logical inverse expression (or use an Otherwise/Log output link). Let us know what the row counts are.
If you are in a Transformer stage, use the expression editor to build the expression; that is, avoid typing column names where possible. Typing only leads to typing errors.
Check your output data set to verify that the expression is satisfied in every row in the data set; your expectation may have been awry.
If you are in a Transformer stage, use the expression editor to build the expression; that is, avoid typing column names where possible. Typing only leads to typing errors.
Check your output data set to verify that the expression is satisfied in every row in the data set; your expectation may have been awry.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.