lookup table - import correct table or edit formula

lookup table - import correct table or edit formula

Anonymous
Not applicable
1,050 Views
2 Replies
Message 1 of 3

lookup table - import correct table or edit formula

Anonymous
Not applicable

hi forum,

 

today i tried to link a lookup table to a width controling parameter of a door.

The idea is to have the keynote determ the properties of the door.

and to use design parameters as "default" or "not found" valeus.

 

i managed to make it work with this morning with the folowing formule:

 

=size_lookup(POLO_lookuptable, "LU_deurpaneel_breedte", vo_deurpaneel_breedte, Keynote)

 

POLO_lookuptable = parameter with name of the csv file

LU_deurpaneel_breedte= lookup colum for return valeu

vo_deurpaneel_breedte= default valeu parameter

keynote = keynote parameter with the look up value

 

But now later in the day it seems like something went wrong and i can't find out how i got this error.

 

i have linked the csv and the screen shot of my door prop's.

in my screenshot i have the "?" value for the keynote wich is meant to not be found and trigger the default value.

In my second screen i use and existing value in the lookup table and i sstill get the same errors.

 

Screenshot 2020-12-18 200700.png

 

Alexander_POLO_0-1608319268273.png

 

 

Screenshot 2020-12-18 200821.png

0 Likes
Accepted solutions (1)
1,051 Views
2 Replies
Replies (2)
Message 2 of 3

Anonymous
Not applicable

Quick update it seems like the error comes from the parameter POLO_lookuptable.

When i use the lookuptable naming directly in the formule it works when i use the naming parameter it doesn't..

any idea's?

 

because i don't see what's wrong with the settings below.

Alexander_POLO_0-1608321589087.png

 



0 Likes
Message 3 of 3

Anonymous
Not applicable
Accepted solution

Learn from your mistakes :)...

 

Solution:

Since the driven parameters are type parameters, the lookup tablme naming should be placed as a formula.

Only then it will be used by all family types.

 

hope somebody can use this too :).

Alexander_POLO_0-1608322718830.png

 

0 Likes