Joining one table at two different points

[Joo525]

Hi,

I am writing the SQL script for ma Qlik Sense App.

I have joined several tabels to two main tablesin Qlik Sense. In both of those tabels there is a row with suppliers as a number. Now I want to join a third table (from database) which maps the supplier number to supplier descritpion.

If I join this table to one of the Qlik tables it works. As soon as I join it two the second table simultaneously to the first one it wont work any more.

I hope you can understand my problem.

Thank you for your help!

[Or]

Either join the data into each individual table (rather than loading it as a separate table) or use mapping load for each individual table.

[Sabrina_V]

Use the function ApplyMap

[Joo525]

The Prpoblem is that we talk about something like 500 suppliers. So the Mapping Funtction is not possible.

So it is possible to connect one table at two different aspots?

[Or]

Mapping Load can handle far more than 500 options...

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptP...

[Sabrina_V · Accepted solution]

You can load your table with Supplier code and Supplier Name with prefix MAPPING like this : 

MAP_Supplier:

MAPPING LOAD DISTINCT

SupplierCode,

SupplierName

FROM <My table>;

And then do a ApplyMap

[Joo525]

Thank you very much, it works