topic Re: pulling fields from multiple tables in QlikView

pulling fields from multiple tables

surajap123 — Wed, 23 Apr 2014 08:50:53 GMT

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

Re: pulling fields from multiple tables

ashfaq_haseeb — Wed, 23 Apr 2014 08:52:35 GMT

Hi,

It depends on data model you have.

Instead of joining I would prefer applymap

Regards

ASHFAQ

Re: pulling fields from multiple tables

tresB — Wed, 23 Apr 2014 08:54:50 GMT

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.

Re: pulling fields from multiple tables

MK_QSL — Wed, 23 Apr 2014 08:57:34 GMT

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

Re: pulling fields from multiple tables

surajap123 — Wed, 23 Apr 2014 09:39:09 GMT

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.

Re: pulling fields from multiple tables

Roop — Wed, 23 Apr 2014 10:17:23 GMT

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.