Merging Tables

[schefflera]

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

[sunny_talwar · Accepted solution]

Just do a simple join

Table1:

LOAD Country,

          [Postal Code],

          Productgroup1,

          [Sales Potential]

FROM Source1;

Join (Table1)

LOAD Productgroup1,

          Productgroup2

FROM Source2;