Apply map

[bhavvibudagam]

Hi Experts,

Can any one please help me on this.

Table A:

Load

"Profit Centre" &'_' & "Month-Year" as Key,

"Month-Year",

"Profit Centre"

Country

From c:\.......;

Table B:

Key,

Value,

Budget

From ... temp.qvd;

In the above Table A and Table B is linked with Key.

Is it possible to make those two tables as one. I have to move Value and Budget fields into Table A.

From Table A i have to take the resident for one calculation.

Thanks in advance.

[Peter_Cammaert]

That depends on how you want to treat Value and Budget. A simple answer is Yes. Replace the [Table B] label with LEFT JOIN ([Table A]) and your second table will be joined to the first.

The problem may now be that for each Key value, you may have multiple Country values. And those will cause the Value-Budget combinations to be repeated. Better not aggregate those from [Table A].

If you keep those tables separate in your data model, you will still get a JOIN but the Value-Budget lines will remain distinct for every Key value. No multiplication.

[Anonymous]

CONCATENATE(A)

LOAD     *

RESIDENT B;