Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Multiple fields from different tables in one table

I have the following tables and the respective fields in them

A

ID

CKey

B

CKey

Date

AKey

C

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.

4 Replies
ecolomer
Master II
Master II

For me the best thing would be to use ApplyMap.

A:

MAPPING LOAD

     CKey,

     ID

from ....

C:

MAPPING LOAD

     AKey,

     Appl

from ....

B:

LOAD

     CKey,

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

     Date

     AKey

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

from ....

qlikwiz123
Creator III
Creator III
Author

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

ecolomer
Master II
Master II

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.

juraj_misina
Luminary Alumni
Luminary Alumni

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