topic Re: Problem with left join in Francophones

Problem with left join

Fri, 24 Apr 2015 08:07:36 GMT

Hi everybody,

I'm facing an issue while using left join in load script.

I have for example this following script :

Table1:

LOAD A as ID,

B as mont,

FROM

(ooxml, embedded labels, table is Feuil1);

Data:

LOAD * INLINE [

ID, Type, Value

1, X, 10

2, X, 20

4, Y, 30

];

Left join (Data)

LOAD ID,

mont - Value as Mont_Value

resident Table1;

My problem is that I can not use the field Value from table Table1 while joining.

Is there a way to do this in qlikview ?

Re: Problem with left join

yvesqlik — Fri, 24 Apr 2015 09:15:41 GMT

Bonour,

pour faire l'addition tu dois mettre les deux collones dans un même tableau

Table1:

LOAD A as ID,

B as mont,

FROM

(ooxml, embedded labels, table is Feuil1);

left join

LOAD * INLINE [

ID, Type, Value

1, X, 10

2, X, 20

4, Y, 30

];

Table2:

nonconcatenate

load

ID,

mont,

Type,

Value

resident Table1;

Table3:

nonconcatenate

load

mont - Value as Mont_Value,

resident Table2;

drop tables Table1, Table2;

Eh voilà!

Cordialement,

Yves

Re: Problem with left join

mambi — Fri, 24 Apr 2015 09:17:42 GMT

Hello,

you can't do : mont - Value as Mont_Value because the filed "Value" doesn't belong to Table1 so the solution is :

....

Data:

LOAD * INLINE [

ID, Type, Value

1, X, 10

2, X, 20

4, Y, 30

];

Left join (Data)

LOAD ID, mont
resident Table1;

Final:
LOAD ID, mont -Value as Mont_Value Resident Data;

drop tables Data, Table1

Re: Problem with left join

ankitaag — Fri, 24 Apr 2015 10:15:48 GMT

Hello Patrick,

Try this,

Table1:

Load A as ID,

B as mont,

Inline [

A,B,C

];

left join

Data:

LOAD * INLINE [

ID, Type, Value

1, X, 10

2, X, 20

4, Y, 30

];

Table2:

Load ID,mont-Value as Mont_Value

Resident Table1;

drop table Table1;

Re: Problem with left join

Fri, 24 Apr 2015 11:03:15 GMT

Merci çà marche !

Re: Problem with left join

ankitaag — Fri, 24 Apr 2015 11:11:24 GMT

Thankyou for marking the answer as helpful..

Can you mark any1 as the correct 1 so as to close this discussion