Merging Tables

schefflera — Wed, 18 Nov 2015 12:47:29 GMT

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

Re: Merging Tables

sunny_talwar — Wed, 18 Nov 2015 14:47:45 GMT

Just do a simple join

Table1:

LOAD Country,

[Postal Code],

Productgroup1,

[Sales Potential]

FROM Source1;

Join (Table1)

LOAD Productgroup1,

Productgroup2

FROM Source2;

topic Re: Merging Tables in QlikView

Merging Tables

Re: Merging Tables