1 Reply Latest reply: Nov 18, 2015 9:49 AM by Sunny Talwar RSS

    Merging Tables

    Felix Kühn

      Hi guys,

       

      could you help me merging two tables please.

       

      Table 1:

       

      Country, Postal Code, Productgroup1, Sales Potential

      DE, 54231, Wood, 1000

      DE, 85421, Wood, 1500

      DE, 98756, Wood, 800

      DE, 54231, Glass, 800

      DE, 85421, Glass, 1200

      DE, 98756, Glass, 1050

       

      Table 2:

       

      Productgroup1, Productgroup2

      Wood, Window

      Wood, Chair

      Wood, Table

      Glass, Wall

      Glass, Plate

      Glass, Cup

       

       

      The result should be like table 3:

       

      Table 3:

      DE, 54231, Wood, Window, 1000

      DE, 54231, Wood, Chair, 1000

      DE, 54231, Wood, Table, 1000

      DE, 85421, Wood, Window, 1500

      DE, 85421, Wood, Chair, 1500

      DE, 85421, Wood, Table, 1500

      ...

      DE, 98756, Glass, Wall, 1050

      DE, 98756, Glass, Plate, 1050

      DE, 98756, Glass, Cup, 1050

       

       

      If you have any idea, i would highly appreciate your help.

       

      Thx in advance.

      Felix