QlikView Forums & Resources
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is locked
: Sep 28, 2012 5:47 PM by Bradley Coyne
Connecting tables and avoiding circular reference
Sep 28, 2012 5:47 PM
Hi All i need help with the following;
i am putting together two source systems thorugh the following logic.
i aim to derive a unique customer price for each timecode connected a relative artno which in turn is connected to a project number, with a specific customer attached to that project.
Table 1: PriceList - (Unique Customer Table that is linked to individual pricing scheme through use of an article number) - DB1
Table 2 links to the transactional table. (see db model pic attached for logic description)
Table 2: TimeCode - Table that connects to the transactional table and tells it which artno is been used in the project. - DB2
any modelling tips on how to create this relationship without running into circualr refernce and recieving the right price to the right project project number?
This content has been marked as final.
Show 0 replies
Remove from profile
Feature on your profile
More Like This
Retrieving data ...