topic Re: Multiple fields from different tables in one table in QlikView

Multiple fields from different tables in one table

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

I have the following tables and the respective fields in them

CKey

Date

AKey

Appl

I want ID, Date, Appl in a single table. How do I achieve this? Left Join? Or ApplyMap to peek into? Please help and suggest.

Re: Multiple fields from different tables in one table

ecolomer — Wed, 10 Jan 2018 17:07:57 GMT

For me the best thing would be to use ApplyMap.

MAPPING LOAD

CKey,

from ....

MAPPING LOAD

AKey,

Appl

from ....

LOAD

CKey,

ApplyMap('A', CKey, '--') as ID,

Date

AKey

ApplyMap('C', AKey, '--) as Appl

from ....

Re: Multiple fields from different tables in one table

qlikwiz123 — Wed, 10 Jan 2018 18:37:19 GMT

The tables with Mapping load are not loading. The load doesn't even go there, to these tables with Mapping Load

Re: Multiple fields from different tables in one table

ecolomer — Wed, 10 Jan 2018 19:52:06 GMT

When you load a table with MAPPING LOAD, the table is not visualized because it is virtual and only serves to be used in ApllyMap.

In my example, I have not finished writing the LOAD clauses and I have left it with the from ....

Send my some real values and I write the script for these data.

Re: Multiple fields from different tables in one table

juraj_misina — Wed, 10 Jan 2018 23:09:07 GMT

Hi,

this really depends on your data and what you need to achieve. In some cases you could be perfectly OK with Left Join or Outer Join, while in other cases I'd go with what ecolomer suggests.

Juraj