Announcements

Announcement: We’re aware of an issue affecting starting a new topic from category pages and creating new blog posts. New topics can still be started directly from the relevant board. Learn more here.

create a lookup table, parameter names are case sensitive

create a lookup table, parameter names are case sensitive

Anonymous
Not applicable
5,041 Views
11 Replies
Message 1 of 12

create a lookup table, parameter names are case sensitive

Anonymous
Not applicable

i want just create a plane as per the size thickness should select from table, details are attached please help

0 Likes
Accepted solutions (1)
5,042 Views
11 Replies
Replies (11)
Message 2 of 12

martijn_pater
Advisor
Advisor

Sure you're not looking for a type catalog?

0 Likes
Message 3 of 12

barthbradley
Consultant
Consultant

https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2018/EN...

 

Here's a much better one.  Just for fun, count how many time the guy says "confusing" or some variation of the word "confusing". 

 

https://www.youtube.com/watch?v=USqZc-VE95Y

0 Likes
Message 4 of 12

Anonymous
Not applicable

Please review my screen shot 

0 Likes
Message 5 of 12

barthbradley
Consultant
Consultant

The Lookup Value has to be in the First Column.  

0 Likes
Message 6 of 12

Anonymous
Not applicable

This table I created same way,

0 Likes
Message 7 of 12

Anonymous
Not applicable

We have 

L, W, thickness. So we column is thickness,  look up value L 

 

Can you please check formula? 

size_lookup(table,"thickness", 100mm,L)

 

 

0 Likes
Message 8 of 12

barthbradley
Consultant
Consultant
Accepted solution

Honestly, I don't know how the heck this works or what you expect it to do, but your first mistake is the first value. Should be "look up table" not "table".  

 

First mistake.jpg

 

 

0 Likes
Message 9 of 12

martijn_pater
Advisor
Advisor

You should watch the video @barthbradley added, see if that helps you. Also you are using a type parameter, whereas look-up tables generally use an instance parameter. Don't know if it matters tbh, but that's from the knowledge page...

 

The size_lookup function is intended for instance parameters. If you want to use tabular data to define types with unique values for each type, create a type catalog

0 Likes
Message 10 of 12

Anonymous
Not applicable

That file name is    table.csv

0 Likes
Message 11 of 12

barthbradley
Consultant
Consultant

@Anonymous wrote:

That file name is    table.csv


 

Yes, I know.  What's your point? 

Message 12 of 12

Anonymous
Not applicable

thanks dear,

 

the mistake which i did ,in formula i have to put parameter name of file name, now it is working.

0 Likes