Calculation between two Resident Tables

[#1]

I have the following script and I want to do the calculations over fields loaded from two resident tables

(example : B*Y/C*Z  as 'W') and keep in Level1 table. How it could be possible ?

Level1:

Load   A, B , C
Resident  P

left join (Level1)

Load C, Y, Z
Resident Q;

[maxgro · Accepted solution]

Level1:

Load   A, B , C
Resident  P
left join (Level1)
Load C, Y, Z
Resident Q;

Final:

noconcatenate load

A, B, C, Y, Z,

B*Y/C*Z  as W

resident

Level1;

drop  tableLevel1;

or I'm missing something?

[MK_QSL]

may be like this...

M1:

Mapping Load * Inline

[

  C, Y,

  30, 40

];

M2:

Mapping Load * Inline

[

  C, Z,

  30, 50

];

T1:

Load

  *,

  B*ApplyMap('M1',C)/C*ApplyMap('M2',C) as W

Inline

[

  A, B, C

  10, 20, 30

];

[MK_QSL]

Or

M1:

Mapping Load * Inline

[

  C, Y,

  30, 40

];

M2:

Mapping Load * Inline

[

  C, Z,

  30, 50

];

T1:

Load * Inline

[

  A, B, C

  10, 20, 30

];

NoConcatenate

Final:

Load

  *,

  B*ApplyMap('M1',C)/C*ApplyMap('M2',C) as W

Resident T1;

Drop Table T1;

[#5]

Thank you very much ! It helped !