topic Re: Merge/combine two tables in QlikView

Merge/combine two tables

Sun, 29 Jun 2014 14:49:05 GMT

Hello everyone,

I have two tables (Care and Model) as I want to combine into a table

Table 1 (Car)

CarID Car

1 Volvo

2 Ford

Table 2 (Model)

CarID Model

1 V70

1 S40

1 XC60

2 C-max

2 Focus

The combined table should be so:

CarID Car Model

1 Volvo V70, S40, XC60

2 Ford C-max, Focus

How should I write the script for this?

Thanks in advance.

Re: Merge/combine two tables

PradeepReddy — Sun, 29 Jun 2014 15:19:35 GMT

Instead of script, we can achieve this at Chart level also....

create a straight table and enable the 'NoTotal' option in expression tab

Dimensions: CarID, Car

Expression : =Concat(Model,',')

Regards

Pradeep

Re: Merge/combine two tables

Sun, 29 Jun 2014 15:28:34 GMT

Many thanks Pradeep, I would like to fix it in the script to use "Model" in a straight table-object (not raktabell through chart-objects).

Best regards

Stravan

Re: Merge/combine two tables

PradeepReddy — Sun, 29 Jun 2014 15:32:53 GMT

At scipt Level....

Cars:

Load * inline

[

CarID,Car

1,Volvo

2,Ford

];

Left Join(Cars)

Model:

Load * inline

[

CarID,Model

1,V70

1,S40

1,XC60

2,C-max

2,Focus

];

NoConcatenate

New_Table:

Load

CarID,

Car,

Concat(Model,',') as Model

Resident Cars

group by CarID,Car;

Drop table Cars;

Regards,

Pradeep

Re: Merge/combine two tables

maxgro — Sun, 29 Jun 2014 15:39:41 GMT

this is the script

but I would keep the 2 tables and, when you need it, concat in chart

Table1:

load * inline [

CarID , Car

1 , Volvo

2 , Ford

];

Left join (Table1)

load CarID, concat(Model, ', ') as Model group by CarID;

load * inline [

CarID , Model

1 , V70

1 , S40

1 , XC60

2 , C-max

2 , Focus

];

Re: Merge/combine two tables

Sun, 29 Jun 2014 15:55:36 GMT

It was good, thank you very much.

Best regard

Stravan