topic Re: Apply map in QlikView

Apply map

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Apply map

Peter_Cammaert — Mon, 04 Dec 2017 11:00:03 GMT

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.

Re: Apply map

Anonymous — Mon, 04 Dec 2017 12:15:25 GMT

CONCATENATE(A)

LOAD *

RESIDENT B;