topic Re: Concatenate after LeftJoins in QlikView

Concatenate after LeftJoins

hvfalcao — Thu, 07 Jan 2016 19:58:19 GMT

Hello!

I have 4 tables:

Pay	Receive
PagarMov: IDPRM, IDPAGAR, VLMOV, DATEMOV;	ReceberMov: IDPRM, IDRECEBER, VLMOV, DATEMOV;
Pagar: IDPAGAR, DATEVENC, IDCATEGORY;	Receber: IDRECEBER, DATEVENC, IDCATEGORY;

Pay

Receive

PagarMov:

IDPRM,

IDPAGAR,
VLMOV,

DATEMOV;

ReceberMov:

IDPRM,

IDRECEBER,
VLMOV,

DATEMOV;

Pagar:

IDPAGAR,

DATEVENC,

IDCATEGORY;

Receber:

IDRECEBER,

DATEVENC,

IDCATEGORY;

What I'm trying to is:

PagarMov LEFT JOIN Pagar
ReceberMov LEFT JOIN Receber

THEN

PagarMov Concatenate ReceberMov:

TheResult:

IDPRM,

IDPAGAR,

IDRECEBER,

VLMOV,
DATEMOV,

DATEVENC,

IDCATEGORY

After that I´ll need to concatenate to another table again

I'm struggling on this!

Thank you!

Re: Concatenate after LeftJoins

Anonymous — Thu, 07 Jan 2016 20:45:13 GMT

Sounds achievable. What bit are you struggling with ?

Re: Concatenate after LeftJoins

maxgro — Thu, 07 Jan 2016 20:47:00 GMT

PagarMov:

load * inline [

IDPRM, IDPAGAR, VLMOV, DATEMOV

1,1,1,1

];

Left join (PagarMov)

load * inline [

IDPAGAR,DATEVENC,IDCATEGORY

1,1,1

];

ReceberMov:

load * inline [

IDPRM,IDRECEBER,VLMOV,DATEMOV

2,2,2,2

];

left join (ReceberMov)

load * inline [

IDRECEBER,DATEVENC,IDCATEGORY

2,2,2

];

concatenate (PagarMov)

load * Resident ReceberMov;

DROP Table ReceberMov;

Re: Concatenate after LeftJoins

hvfalcao — Thu, 07 Jan 2016 21:00:26 GMT

Thank you maxgro‌ !!

I wasn't thinking about the Resident Load!

Re: Concatenate after LeftJoins

Anonymous — Thu, 07 Jan 2016 21:37:01 GMT

Just as an aside, if you wanted you could avoid the resident load like this.

PagarMov:

load * inline [

IDPRM, IDPAGAR, VLMOV, DATEMOV

1,1,1,1

];

concatenate (PagarMov)

load * inline [

IDPRM,IDRECEBER,VLMOV,DATEMOV

2,2,2,2

];

left join (PagarMov)

load * inline [

IDRECEBER,DATEVENC,IDCATEGORY

2,2,2

];

Left join (PagarMov)

load * inline [

IDPAGAR,DATEVENC,IDCATEGORY

1,1,1

];

Re: Concatenate after LeftJoins

hvfalcao — Fri, 08 Jan 2016 12:02:19 GMT

Bill,

That's what I've tried at the first time. I don't know why, but it won't result as expected. The last left join won't join correctly.