pulling fields from multiple tables

[surajap123]

hi,

To create a calculated field, I need multiple fields which are present in different tables in data model.

To achieve this, the solution I have is create a table (say table1) with required fields by left joining other tables and then I use this table1 as a resident.

Is there any simple way to achieve this?

Regards,

Suraj

[ashfaq_haseeb]

Hi,

It depends on data model you have.

Instead of joining I would prefer applymap

Regards

ASHFAQ

[tresesco]

It all depends on your data model. If the tables are properly associated(linked), you might not have to bring all the fields into a single table, you could simply refer them as if one.

[MK_QSL]

Provide your data model or apps or sample files...

[surajap123]

Thanks a lot for the valuable inputs.

I am here providing a sample source tables. Most of the tables have repetition of fields.

To avoid the synthetic keys, I have used qualify statments.

In source transaction database-

Table1 and Table2 are connected using field1

Table2 and Table3 are connected using field12

I want to create a calculated field using-

-field10

-field14

-field19

As you can see these 3 fields are in different table.

What could be the best data model one can create in qlikview using these source tables.

[Roop · Accepted solution]

Use Mapping Load and ApplyMap to load different fields from different tables. The examples given in the help are very useful and provide what you require.

The only useful advice I can give is to load the lookup (Mapping Load) both with the Mapping statement and without to debug the process as the Mapping Loads do not appear in your table layouts. You can also nest ApplyMaps if required to make a join across multiple tables.