topic create a lookup table, parameter names are case sensitive in Revit Architecture Forum

create a lookup table, parameter names are case sensitive

Anonymous — Thu, 01 Oct 2020 14:27:50 GMT

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

Re: create a lookup table, parameter names are case sensitive

martijn_pater — Thu, 01 Oct 2020 14:33:36 GMT

Sure you're not looking for a type catalog?

Re: create a lookup table, parameter names are case sensitive

barthbradley — Thu, 01 Oct 2020 15:37:53 GMT

https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2018/ENU/Revit-Customize/files/GUID-91270AEF-225A-49D7-BF84-1F44D1E3E216-htm.html

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

Re: create a lookup table, parameter names are case sensitive

Anonymous — Thu, 01 Oct 2020 15:49:06 GMT

Please review my screen shot

Re: create a lookup table, parameter names are case sensitive

barthbradley — Thu, 01 Oct 2020 15:51:53 GMT

The Lookup Value has to be in the First Column.

Re: create a lookup table, parameter names are case sensitive

Anonymous — Thu, 01 Oct 2020 16:29:18 GMT

This table I created same way,

Re: create a lookup table, parameter names are case sensitive

Anonymous — Thu, 01 Oct 2020 17:02:06 GMT

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)

Re: create a lookup table, parameter names are case sensitive

barthbradley — Thu, 01 Oct 2020 17:07:02 GMT

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".

Re: create a lookup table, parameter names are case sensitive

martijn_pater — Thu, 01 Oct 2020 19:29:54 GMT

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

Re: create a lookup table, parameter names are case sensitive

Anonymous — Fri, 02 Oct 2020 00:32:06 GMT

That file name is table.csv

Re: create a lookup table, parameter names are case sensitive

barthbradley — Fri, 02 Oct 2020 00:34:05 GMT

@Anonymous wrote:
That file name is table.csv

Yes, I know. What's your point?

Re: create a lookup table, parameter names are case sensitive

Anonymous — Sat, 03 Oct 2020 05:24:12 GMT

thanks dear,

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