Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Just do a simple join
Table1:
LOAD Country,
[Postal Code],
Productgroup1,
[Sales Potential]
FROM Source1;
Join (Table1)
LOAD Productgroup1,
Productgroup2
FROM Source2;
Just do a simple join
Table1:
LOAD Country,
[Postal Code],
Productgroup1,
[Sales Potential]
FROM Source1;
Join (Table1)
LOAD Productgroup1,
Productgroup2
FROM Source2;