topic Re: Link multiple fields in table to other (master) data table in App Development

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

harm_dataspark — Wed, 09 Feb 2022 16:19:26 GMT

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?

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

hic — Wed, 09 Feb 2022 16:25:09 GMT

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

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

AG-gugelbisolutions — Wed, 09 Feb 2022 16:26:06 GMT

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.

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

harm_dataspark — Fri, 11 Feb 2022 15:17:05 GMT

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