topic Re: Multiple connected tables with a look up table in App Development

Multiple connected tables with a look up table

SI_NY02 — Tue, 01 Aug 2023 20:09:24 GMT

I have 3 tables that all connect using a primary key of CustomerID. All of these tables also have a store_id field that is specific to that table. I then have a lookup table with store_id information which include information like store name and other store identifier information. When I try to load these I'm getting loop errors. What is the best way to load these?

Transaction table

Customer ID

Order ID

Store ID

Sales Amount

Application table

Customer ID

Store ID

Date

Customer table

Customer ID

Customer status

Store ID

Customer Address

Store ID Lookup Table

Store ID

Store Name

Store Type

Re: Multiple connected tables with a look up table

BrunPierre — Tue, 01 Aug 2023 22:09:31 GMT

Well, it ultimately depends on the data model and the specific questions that will be asked based on it. In any case, you could CONCATENATE the three tables and then link the attributes of the store to the resultant table.

Re: Multiple connected tables with a look up table

SI_NY02 — Tue, 01 Aug 2023 22:03:28 GMT

Can you show me how it would look?

Re: Multiple connected tables with a look up table

BrunPierre — Tue, 01 Aug 2023 22:21:08 GMT

TAC:
LOAD [Customer ID],
[Order ID],
[Store ID],
[Sales Amount]

FROM Transaction_table;

Concatenate
LOAD [Customer ID],
[Store ID],
Date

FROM Application_table;

Concatenate
LOAD [Customer ID],
[Customer status],
[Store ID],
[Customer Address]

FROM Customer_table;

Store:
LOAD Distinct [Store ID]
Resident TAC;

Left Joins (Store)
LOAD [Store ID],
[Store Name],
[Store Type]

FROM Store;

Re: Multiple connected tables with a look up table

SI_NY02 — Wed, 02 Aug 2023 13:26:00 GMT

Awesome. Thank you!