Left Join within if condition

[Matteo1990]

Hello everyone,

I'm not able to solve this problem, trough a left join within if condition i need to "convert" these two tables:

Table A:                  Table B:

Code1   Value        Code1    Code2

A           100€            A               B

B           150€            A               C

C           100€         

In this table :

Code1   Value

A              100€

A              150€

A              100€

Thanks for your help

[sunny_talwar]

Try it using ApplyMap instead

MappingTableB:
Mapping
LOAD Code2,
	 Code1;
LOAD * INLINE [
    Code1, Code2
    A, B
    A, C
];

TableA:
LOAD RowNo() as RowNum,
	 ApplyMap('MappingTableB', Code1) as Code1,
	 Value;
LOAD * INLINE [
    Code1, Value
    A, 100
    B, 150
    C, 100
];

[Matteo1990]

Thanks a lot, your solution fit perfectly!