Problem with left join

[#1]

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,

    C

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 ?

[marcus_malinow]

Data:

LOAD A as ID,

    B as mont,

    C

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;

[anbu1984]

Table1:

LOAD A as ID,

    B as mont,

    C

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

];