1 Reply Latest reply: Aug 12, 2016 5:30 AM by Sunny Talwar RSS

    Populate Unique ID to join table

    Deepak Sharma

      Hi

       

      I have the requirement to join table to populate Trader name.

       

      Can some one help me out with the situation i dont have any Unique ID to join.

       

      For Example

      Table A:

      CountryBusiness LineSub Business LineTrader
      IndiaFinanceF1Trader1
      IndiaFinanceF2Trader2
      FranceFinanceF1Trader3
      USFinanceF1Trader1

       

       

       

      Table B

      CountryBusiness LineSub Business LineBal
      IndiaFinanceF15456
      FranceFinanceF16464
      FranceFinanceF25656
      USFinanceF165456
      USFinanceF2564564

       

       

      Desired Output:

      CountryBusiness LineSub Business LineTraderBal
      IndiaFinanceF1Trader15456
      FranceFinanceF1Trader36464
      FranceFinanceF2-5656
      USFinanceF1Trader165456
      USFinanceF2-564564