0

Link= issue universal connection

Dorka Cruz

September 13, 2017 13:57

None

Follow

I'm having an issue where the filter I used with Linking to another table is not producing the correct results

in the data dump cell I have the following formula (note the PBN table doesn't have a primary key and the same may go with the grp_plan table):

=NL("Rows","PBN",{"CAP_RATE","GRP_NBR","INSURER","PBN","PREMIUM","PLAN_TYPE"},"DataSource=","Oracle","INSURER",$C$5,"GRP_NBR",$F12,"+PLAN_TYPE","*","+PBN","*","Link=","GRP_PLAN","GRP_NBR","=GRP_NBR","EXP_DATE","@@")

Results:

But the table Grp_Plan reflects this:

And the PBN table reflects this:

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Sarah Kloser September 13, 2017 14:02

  Hi Dorka!

  I think the issue is that Jet is getting confused. You are filtering on GRP_NBR and then linking the tables on the same field. Try filtering on GRP_NBR within the GRP_PLAN table like this:

   

  =NL("Rows","PBN",{"CAP_RATE","GRP_NBR","INSURER","PBN","PREMIUM","PLAN_TYPE"},"DataSource=","Oracle","INSURER",$C$5,"+PLAN_TYPE","*","+PBN","*","Link=","GRP_PLAN","GRP_NBR","=GRP_NBR","EXP_DATE","@@","GRP_NBR",$F12)

  SLK

   

• 0
  
  Dorka Cruz September 13, 2017 14:14

  Didn't work I got the same result.