Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

schefflera
New Contributor III

Merging Tables

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

1 Solution

Accepted Solutions

Re: Merging Tables

Just do a simple join

Table1:

LOAD Country,

          [Postal Code],

          Productgroup1,

          [Sales Potential]

FROM Source1;

Join (Table1)

LOAD Productgroup1,

          Productgroup2

FROM Source2;


Capture.PNG

1 Reply

Re: Merging Tables

Just do a simple join

Table1:

LOAD Country,

          [Postal Code],

          Productgroup1,

          [Sales Potential]

FROM Source1;

Join (Table1)

LOAD Productgroup1,

          Productgroup2

FROM Source2;


Capture.PNG

Community Browser