August 22, 2008 at 2:56 pm
I have this simple Package and a dataflow. I select my query for source then i do the conditinal split . Further I do the conditional split and do a simple LookUP to a codelist table and based on that lookup i further do conditional split. I have attach a screen shot of it.
But lookUps fails without enough error message. But when i do error configure all the rows moves to error table.
I am sure that the VEND_ID , that i select in my data flow are populated in COdelist table as Codevalue. Then I select Description from COdelist table and add that column in my pipeline. based on thsis descrption value i do my conditional splits. However all the rows are moves to redirect errorr rows, and igf I move this step , LOOKUP fails.
There is something ia m missing or Is this A BUG
August 22, 2008 at 5:40 pm
Gyanendra
You mentioned that everything is going in error log or lookup is failing.
I think there may be some different issue that is causing records to be errored out.
Is it possible for you to check error message and post it here
🙂
August 22, 2008 at 6:37 pm
I'm guessing you are getting no matching row is found. This is because the Lookup component is case-sensitive and is actually fairly well-known to struggle when the lookup is on a string. Check out this blog post:
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 23, 2008 at 7:50 am
Jack u r a Geni.......s!! I solved the problem. Jack is right, it was not the prblem with case , but string. I found out that the lenght of the data were different then the lookup table. One more knowledeg in my account. But , guys it worked well when i do the join.
LIke when I run this query....
SELECT * from codelist c
ineer join hdr h
on c.codevalue = h.hdr
this gave me all the matches, but in the lookup it was failing becoz hdr data was like 'NT2048 '.
there was this empty string and i belive lookup does exact match. Trim finction worked for me
SELECT datalength ('NT2345 ') , len('NT2345 ') , TRIM(len('NT2345 '))
gives several values
Thanks to all out there
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply