4 Replies Latest reply: Aug 15, 2012 4:07 AM by borislav RSS

    How to associate values of one table to columns of another

      Hi,


      I have two tables (one from DB & another from an excel sheet) as shown below. I need to associate values from Table 1 to the columns of Table 2. Is there a function that can handle this? Can Crosstable refrence handle this and form this assoication? Pls help. Thanks!

       

       

      Table 1:

       

      FIELD NAMEFIELD VALUEFIELD DESCRIPTION
      CRED_CARD_TY1 General Purpose
      CRED_CARD_TY2Private Label
      CRED_CARD_TY3Business Card
      CRED_CARD_TY4Corporate Card
      PROD_TY5Product One

       

      Table 2:

       

      CRED_CARD_TYPROD_TY
      35
      15
      25
      35
      15
      45
      45
      15
      15