Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Look Up Table help

5 ANTWORTEN 5
GELÖST
Antworten
Nachricht 1 von 6
Jes_Gonzalez
488 Aufrufe, 5 Antworten

Look Up Table help

Hello peeps, I'm having an issue with look up table. I'm no pro i'm on revit 2018.3 and my question is if its possible to create a look up table to also contain text and numbers. My goal is to create a look up table with for instance a ball valve family, so this family will have different sizes and i want the part number to change with the size. This what i have so far. My look up table works perfect but i'm scratching my head trying to add text with number for product numbers. I know it should be in length or inches.  Any help will be greatly appreciated.look up.JPG

5 ANTWORTEN 5
Nachricht 2 von 6
barthbradley
als Antwort auf: Jes_Gonzalez

Might be too convoluted, but you could do an integer which would be evaluated through an if statement in the family to return a text value. 

 

if(integer=1, "N1", if(integer=2, "S3, if(integer=3, "U7", ....

Nachricht 3 von 6
Jes_Gonzalez
als Antwort auf: barthbradley

I was looking for something anyone can edit with knowing much of revit families. Goal is to have a look up table along with part ids and as they change have someone edit and reload the look up table.

Nachricht 4 von 6
Jes_Gonzalez
als Antwort auf: Jes_Gonzalez

 

 

Figured it out.

Make sure to add your text on the 1 column like the highlighted.

 

size_lookup(Look Up Table, " ", " ", D)

look up.JPG1.JPG

Nachricht 5 von 6
barthbradley
als Antwort auf: Jes_Gonzalez

Huh? Not sure I understand your solution. What does size_lookup(Look Up Table, " ", " ", D) do? It's not an evaluation.  What value is returned?  

Nachricht 6 von 6
Jes_Gonzalez
als Antwort auf: barthbradley

Sorry, I wanted to use a look up table to keep track of product number that consisted of number and text. So for instance if i have 1/4" valve it will retrieve HPH25 and autosize to whatever the pipe diameter is. So in the future if we need to change/update product numbers all we have to do is update the .csv file and reload the family.

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report