topic Re: Joining one table at two different points in App Development

Joining one table at two different points

Joo525 — Fri, 15 Nov 2024 21:52:32 GMT

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!

Re: Joining one table at two different points

Or — Mon, 24 Apr 2023 10:40:19 GMT

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

Re: Joining one table at two different points

Sabrina_V — Mon, 24 Apr 2023 11:54:51 GMT

Use the function ApplyMap

Re: Joining one table at two different points

Joo525 — Mon, 24 Apr 2023 12:10:58 GMT

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?

Re: Joining one table at two different points

Or — Mon, 24 Apr 2023 12:12:14 GMT

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

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

Re: Joining one table at two different points

Sabrina_V — Mon, 24 Apr 2023 12:15:07 GMT

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

Re: Joining one table at two different points

Joo525 — Mon, 24 Apr 2023 12:40:26 GMT

Thank you very much, it works