Pre-look up condition Failing even values are matching
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 148
- Joined: Thu Apr 10, 2008 12:47 am
Pre-look up condition Failing even values are matching
Hi,
I have one multi-instace job which is failing due to pre-look condition mistmatch even though the values are matching.
thr condition is
NullToZero(total_row_Amt)=NullToZero(Source_TOT_AMT)
values are
000159981855319403.000= 000159981855319403.000
however when i remove NullToZero function job run successfully
total_row_Amt=Source_TOT_AMT
i could have simply done this but this is Multi-instance job and used across mny sequece so can not risk to change this.
total_row_Amt and Source_TOT_AMT have data type decimal (21,3)
but there source are aggegation of sevel 100 columns have simmilar datatype.
seeking help on this..please let me know for further information.
Thanks and regards,
Devesh
I have one multi-instace job which is failing due to pre-look condition mistmatch even though the values are matching.
thr condition is
NullToZero(total_row_Amt)=NullToZero(Source_TOT_AMT)
values are
000159981855319403.000= 000159981855319403.000
however when i remove NullToZero function job run successfully
total_row_Amt=Source_TOT_AMT
i could have simply done this but this is Multi-instance job and used across mny sequece so can not risk to change this.
total_row_Amt and Source_TOT_AMT have data type decimal (21,3)
but there source are aggegation of sevel 100 columns have simmilar datatype.
seeking help on this..please let me know for further information.
Thanks and regards,
Devesh
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
-
- Participant
- Posts: 148
- Joined: Thu Apr 10, 2008 12:47 am
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
-
- Participant
- Posts: 148
- Joined: Thu Apr 10, 2008 12:47 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm wondering if it's imprecision in decimal storage, though your precision and scale look OK for the values you're using. As a test, can you try converting them to string for the purpose of comparison?
Amending Suzanne's suggestion slightly, can you use a reject link and set your Condition Not Met rule to "output"? Again, this is just for test purposes.
Amending Suzanne's suggestion slightly, can you use a reject link and set your Condition Not Met rule to "output"? Again, this is just for test purposes.
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.