Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Order Header:
LOAD
Order ID,
Order Date,
Customer ID,
SalesRepID,
Sub Total,
Modified Date,
Total Due
FROM Order Header;
Item Request:
LOAD
ItemRequestID,
ItemRequestTypeID,
Order ID,
Company
Modified Date,
Customer Name
FROM Item Request;
Customer:
LOAD
Customer ID,
Customer Code,
Customer Name,
Modified Date
SalesRepID
FROM Customer;
Order Version:
LOAD
Version Id,
Order ID,
Total Due
Modified Date
FROM Order Version;
How to design Data Model?
Ramu
Please Help Me
Thank You.
Or send me any specific requirement, you want
Dear Ramanjaneyulu,
I hope you are looking for this one.
Kindly find attached App and Data Model.
Kind regards,
Ishfaque Ahmed
Thank you
Thank you
How big is your data set?
The queries you posted are quite well structured and may be sufficient. QV will automatically create the associations on the common field names, but with that date I see no composite keys or a need to do any transformations.
If your data set is large (>>10 million rows or more), then some optimisation may be necessary, subject to testing.
PFA...
If your question has been answered, please close off this thread by indicating an answer.