Link multiple fields in table to other (master) data table

[harm_dataspark]

Hi there, I have the following situation//tables:

[Suppliers]:
Load
	SupplierID,
	SupplierName,
	....

[Items]:
Load
	ItemID,
	ItemDescription,
	ItemSupplierID1,
	ItemSupplierID2,
	ItemSupplierID3
	....

In the app I want to create an overview of all items including the name of the Supplier1-3. Though a mapping load could be used to solve that one, I also want to be able to select a Supplier and view ALL ITEMS linked to that supplier, whether it is supplier1, 2 or 3.

Any suggestions how to solve that?

[hic]

[Items]:
Crosstable (SupplierNo, SupplierID, 2)
Load
ItemID,
ItemDescription,
ItemSupplierID1,
ItemSupplierID2,
ItemSupplierID3
From ...

See also https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083 

[AG-gugelbisolutions · Accepted solution]

Hi there, I would create a table this way:

ITEM_to_SUPPLIER:
LOAD DISTINCT
	ItemID
	ItemSupplierID1 as SupplierID
RESIDENT Items;

CONCATENATE (ITEM_to_SUPPLIER)
LOAD DISTINCT
	ItemID
	ItemSupplierID2 as SupplierID
RESIDENT Items;

CONCATENATE (ITEM_to_SUPPLIER)
LOAD DISTINCT
	ItemID
	ItemSupplierID3 as SupplierID
RESIDENT Items;

Hope it helps.

[harm_dataspark]

Though both suggestions might work, I went for the second one (from @AG-gugelbisolutions). Works like  a charm!