I've to do a lookup where the primary & reference link has a field with value like 'ABC',but the hit was not happening.
Since it was a varchar field, I tried triming the trailing & leading spaces,even after also that it was not working.
When i pass this field through a filter or tranformer with constraint like 'fileld=ABC' for both the primary & reference links before doing a lookup, the records with particular contraint was not getting filtered in the reference link.
What could be the problem.
Awaiting for your reply in this regard.
Problem with the lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2007 1:58 am
- Location: India
Problem with the lookup
Regards
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2007 1:58 am
- Location: India
Lookup Problem
ArndW wrote:If you run the job with a 1-node configuration, or specify "entire partitioning" for the lookup link, do you still get the same problem? ...
I was using $APT_STRING_PADCHAR environment variable in my job.
I found some spaces padded to that particular field,when i tried to trim it,the spaces are not getting trimmed.
Awaiting for your valuable feedback.
Regards
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2007 1:58 am
- Location: India