Results 1 to 5 of 5

Thread: lookup table with several column to check

  1.    #1
    Member philsogood's Avatar
    Join Date
    June 30, 2016
    Location
    Lyon - France
    Posts
    203
    Current Local Time
    09:28 PM

    Not allowed! Not allowed!

    lookup table with several column to check

    hello
    i'm working on a family where there are 2 materials
    it's a reducer made with PVC or HDPE
    in my lookup table i have columns with dimensions for PVC and columns with dimensions for PE
    i create first the reducer for PVC with formula... it works fine and (as i wasn't really awaken this morning) for for the second type family type i changed formula with the right name for PE..., but it changes too the value in the PVC type!!
    so i tried to find a way to concatenate text in order to the search dimensions in the right column is my formula size_lookup but it doesn't work! (there are several threads talking about this)
    the simplest way would be to create a second family but, as an "artist", i would like to know if it's possible to do it in the same family!
    Phil
    PS : below an extract of the lookup table

  2.    #2
    Forum Co-Founder Alfredo Medina's Avatar
    Join Date
    December 7, 2010
    Location
    Orlando, FL, USA
    Posts
    3,202
    Current Local Time
    03:28 PM

    Not allowed! Not allowed!
    You could either:
    1) Create 2 families, each of them referencing its own lookup table, or...
    2) Split the lookup table information in 2 text files, and then import both files into one family, and then use a formula to determine which file should be use in each case.

  3.    #3
    Member philsogood's Avatar
    Join Date
    June 30, 2016
    Location
    Lyon - France
    Posts
    203
    Current Local Time
    09:28 PM

    Not allowed! Not allowed!
    Quote Originally Posted by Alfredo Medina View Post
    You could either:
    1) Create 2 families, each of them referencing its own lookup table, or...
    2) Split the lookup table information in 2 text files, and then import both files into one family, and then use a formula to determine which file should be use in each case.
    Hi Alfredo
    I know that this solution works but i'd like to know if it's possible to do it in the same family... so many things are possible in the families and i'm discovering it everyday and i thought that there was might be a tip to do it in the same family
    is it possible?
    Phil

  4.    #4
    Forum Co-Founder Alfredo Medina's Avatar
    Join Date
    December 7, 2010
    Location
    Orlando, FL, USA
    Posts
    3,202
    Current Local Time
    03:28 PM

    Not allowed! Not allowed!
    It is possible in the same family, yes. You need to use embedded IFs, something like, "if this value is between this and that, take the size from column "x" in my lookup table, otherwise, if this value is between this and that, take the size from column "y" in my lookup table,... etc.

  5.    #5
    Member philsogood's Avatar
    Join Date
    June 30, 2016
    Location
    Lyon - France
    Posts
    203
    Current Local Time
    09:28 PM

    Not allowed! Not allowed!
    i was thinkig to it today.... great news i'll try it soon
    thanks
    PS : as it's impossible to use text in form¨ulas evaluation a create a new parameter which is linked to the material used for the reducer
    this paramter is hand filled and it works very well!!
    Last edited by philsogood; December 4th, 2019 at 05:56 PM.

Similar Threads

  1. Lookup table
    By gowthamsamys in forum MEP - General
    Replies: 2
    Last Post: April 16th, 2018, 10:48 PM
  2. Lookup Table Using Number
    By Tim_Ea in forum MEP - General
    Replies: 5
    Last Post: January 31st, 2018, 03:03 AM
  3. Lookup table Yes/no not working
    By Arno in forum Architecture - Family Creation
    Replies: 6
    Last Post: September 28th, 2015, 07:21 PM
  4. Lookup Table: First Column?
    By doni49 in forum Architecture - Family Creation
    Replies: 3
    Last Post: September 28th, 2015, 12:09 AM
  5. Lookup Table issue
    By sabari2504 in forum MEP - General
    Replies: 8
    Last Post: January 15th, 2014, 09:19 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •