topic Re: joining two tables in QlikView

joining two tables

Tue, 13 Nov 2012 13:54:03 GMT

Hi everyone,

could you please help me with this issue.

i have two tables

table1:

ID	A	B
1	20	60
2	30	25
4	10	11

TABLE 2:

ID	A	C
3	33	50
5	30	43
6	21	26

AND I NEED THIS

ID	A	B	C
1	20	60
2	30	25
3	33		50
4	10	11
5	30		43
6	21		26

THANKS!

gerardo

Re: joining two tables

its_anandrjs — Tue, 13 Nov 2012 13:58:33 GMT

Hi,

Write script like

table1:

Load * inline

[

ID, A, B

1, 20, 60

2, 30, 25

4, 10, 11

];

TABLE2:

JOIN

load * inline

[

ID, A, C

3, 33, 50

5, 30, 43

6, 21, 26

];

Put Join between two tables.

Regards,

Anand

Re: joining two tables

Tue, 13 Nov 2012 13:59:07 GMT

concatenate(table1)

LOAD *

Resident TABLE 2;

Re: joining two tables

Tue, 13 Nov 2012 14:30:31 GMT

hi Its, if i do what you wrote the load script generate $Syn tables

Re: joining two tables

its_anandrjs — Tue, 13 Nov 2012 14:40:31 GMT

Hi,

You put join between them or can you publish your script for check. If you put join between them no synthetic key is created and only on table is created.

Regards,

Anand

Re: joining two tables

Tue, 13 Nov 2012 14:50:36 GMT

hI marco,

i did it but the script generated a $syn table with %key_ID+%key_A fields

what can i do with this?

thanks

Re: joining two tables

Tue, 13 Nov 2012 16:04:37 GMT

tabella1:

LOAD* inline

[

ID, A, B

1, 20, 60

2, 30, 25

4, 10, 11

];

concatenate(tabella1)

LOAD* inline

[

ID, A, C

3, 33, 50

5, 30, 43

6, 21, 26

];

Re: joining two tables

Tue, 13 Nov 2012 17:46:40 GMT

hi! i tried with outer join and concatenate but the result was this

table1.id	table2.id	a	b	c

but i need this:

id	a	b	c

this is my load script

pagos:

LOAD actualizacion,

baja,

comentario,

direccion,

email,

estado,

estado_pago_gateway,

fecha,

generacion,

id_pago,

id_pago AS %Key_PAGO_ID,

id_pago_dm,

medio_pago,

metodo_pago,

moneda,

monto,

monto_neto,

num_transaccion

FROM

(qvd);

outer join

LOAD acc_id,

actualizacion,

baja,

estado_pago_gateway,

extra_part,

generacion,

id_pago,

id_pago AS %Key_PAGO_ID,

id_pago_mp,

item_id,

mp_op_id,

name,

payment_method,

price,

shipping_amount,

status,

status_description,

total_amount

FROM

(qvd);

what im doing wrong?

thanks!

Re: joining two tables

Thu, 15 Nov 2012 13:23:43 GMT

pagos:

LOAD actualizacion,

baja,

comentario,

direccion,

email,

estado,

estado_pago_gateway,

fecha,

generacion,

id_pago,

id_pago AS %Key_PAGO_ID,

id_pago_dm,

medio_pago,

metodo_pago,

moneda,

monto,

monto_neto,

num_transaccion

FROM

(qvd);

concatenate(pagos)

LOAD acc_id,

actualizacion,

baja,

estado_pago_gateway,

extra_part,

generacion,

id_pago,

id_pago AS %Key_PAGO_ID,

id_pago_mp,

item_id,

mp_op_id,

name,

payment_method,

price,

shipping_amount,

status,

status_description,

total_amount

FROM

(qvd);

Re: joining two tables

Thu, 15 Nov 2012 20:44:44 GMT

Hi marco,

i tried with your script but for example i have two fields call "actualizacion", one from pago_mp and another from pago_dm.

what can i do to merge those fields?

thanks

gerardo

Re: joining two tables

Fri, 16 Nov 2012 09:04:51 GMT

concatenate between two tables

if the field name is same in both the tables

id in both the tables

if ur result is like

t1.id,t2.id --

for this use the unqualify

use alias to change ur field name to id