topic Problem with left join in QlikView

Problem with left join

Fri, 24 Apr 2015 08:22:07 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

marcus_malinow — Fri, 24 Apr 2015 08:23:54 GMT

Data:

LOAD A as ID,

B as mont,

FROM

(ooxml, embedded labels, table is Feuil1);

LEFT JOIN (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 Data;

Re: Problem with left join

anbu1984 — Fri, 24 Apr 2015 08:53:27 GMT

Table1:

LOAD A as ID,

B as mont,

FROM

(ooxml, embedded labels, table is Feuil1);

Map_mont:

Mapping Load ID, mont Resident Table1;

Data:

LOAD *, Applymap('Map_mont',ID,0) - Value as Mont_Value INLINE [

ID, Type, Value

1, X, 10

2, X, 20

4, Y, 30

];