Lookup Table Text value
Accepted solution
jigar.wsp wrote:
"Is that possible to get text value from look up table.
...
For an example if its getting flow value 1-100 then it shows type S1 if 100-150 then S2, 150-200 then S3..."
I don't believe that the Lookup Tables currently support Text data. In the example you have provided, are these "S1", "S2", etc labels determined on a Project-by-Project basis, or does "S1" mean the same thing across all of your Projects? In the case of the former, you can compile a "master" formula that can be placed into all of your Families. In the case of the latter, perhaps you could use an Integer type 'code' in the Lookup Table that gets converted into the proper Text string by standard formulas in the Family.
jigar.wsp wrote:
"I got automatic resizing diffuser based on flow value. Previously I was putting IF condition and resizing on based of flow but its difficult for modeler and engineer to understand how IF condtion works and it may **** whole job."
If you are worried about the modelers/engineers building the formulas, wouldn't you also be worried about them following the proper procedures in editing/managing the Lookup Tables as well? What I have done in the past was to create a file in Excel that would allow the user to input the criteria for the formula in a simple interface, and then have formulas in excel compile the formula to be copy/pasted into Revit. If you would be interested in pursuing this route, just let me know.
Corey D. 
──────────────────────────────────────────────────────────────────────
⁞|⁞ Please use
.Accept as Solution and 
Give Kudos as appropriate to further enhance these forums. Thank you!
──────────────────────────────────────────────────────────────────────
⁞|⁞ Please use
.Accept as Solution and Give Kudos as appropriate to further enhance these forums. Thank you!
Hello,
If you need more than one text extraction use more tables, just take care. I have already used up to 6, but sometimes I had crashes, but on 2015 they didn't happen!
Fábio Sato
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Can you guys help me out, it sounds like I'm having the same issue. I'm wanting to add a product code that is both text and numbers based off the Nominal pipe size. I know the highlighted is part is wrong but any information on how to achieve this would be greatly appreciated. Attached is my look up table. Thank you guys in advance.
Hello,
Use the following header HPH##other##.
Fábio Sato
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
