Lookup logic

dstest · Post by **dstest** » Fri Aug 15, 2008 7:37 pm

I have an lookup file file like below.

Not50,PLAN,HPHC
50,ANY,MEDICA

I have the following input file.

100,PLAN
50,100

Here is the description.

100 means Not50 in the lookup file that means it matched and PLAN matched with PLAN then it should return HPHC.

second row in the input file 50 matches with 50 in the lookupfile second row and 100 means ANY.so it should return MEDICA

Output:

100,PLAN,HPHC
50,100,MEDICA

Both are files only.So how can we acheive this in parallel job by using lookup file stage.Please give me suggestion to perform this lookup.

Thanks

ray.wurlod · Post by **ray.wurlod** » Fri Aug 15, 2008 8:22 pm

Two lookups. The first looks up 50. The result of that goes through a Transformer stage that generates the string "Not50". The second lookup is conditional on the first having failed.

dstest · Post by **dstest** » Fri Aug 15, 2008 8:55 pm

Can you please explain me littile bit detail

chulett · Post by **chulett** » Fri Aug 15, 2008 9:46 pm

He did. You looking for lotta bit detail?

ray.wurlod · Post by **ray.wurlod** » Fri Aug 15, 2008 11:20 pm

What do you not understand about what I posted?