3 Replies Latest reply: Oct 11, 2016 12:58 AM by Sunny Talwar RSS

    Blending tables ... generate a new field

    Casey Johnson

      Hoping someone can help me with this. I would like to see how to join/display table info via a couple of fields from multiple tables. Short version is I need the Table B gen_name field to generate based on the matching model_id fields ..... IF the Table A model_year is between the gen_start_year and gen_end_year.

       

      example: IF (model_year >= gen_start_year & <= gen_end_year, display gen_name)

       

      Table A:

      LOAD

          model_id,

          model_year,

          etc....

      FROM ...

       

      Table B:

      LOAD

          model_id,

          gen_start_year,

          gen_end_year,

          gen_name

      FROM ...

       

      I'm assuming that this process would be best performed in the load editor and I would appreciate seeing what that may look like. I'm still a little unsure where to put additional scripts in the editor so if you could show what the entire script (tables & all) looks like, that would really help me out.