Need help creating table from excel file

twallstr

Registered User.
Local time
Today, 22:31
Joined
Mar 28, 2006
Messages
11
I am stuck with a problem where I need to create a new table from an excel file. In detail my problem is;
The excel file contains an order from a customer, like below,
BOM Component Qty
123 abc 2
123 def 2
234 ert 1
234 qwe 1
234 uio 1

I need to create a table from this data like;
Qty Partno
1 123
4 abc
4 def
1 234
2 ert
2 qwe
2 uio

NB! In reality the components are numbers not letters.
The qty for BOM is always 1 and the component 2xqty.

It is important that the BOM number is listed first and thereafter its components.

So I need to somehow associate the BOM number with its components and list them together as a group.
I just cannot figure out how to do this.

ANy help is greatly appreciated.
 
I think that your table should resemble the Excel file. In fact I would expect two tables, one for the BOM data and a second, linkked table holding the components. The data summary you want would be produced in a report.

Tables are used for storing data. The presentation and order are unimportant and the users should never need to see the tables. The type of sorting and grouping you want is easilly accomplished in a form for on screen display or a report which may be on screen or printed.

It's not obvious why your component quantities are double the number in the table???
 

Users who are viewing this thread

Back
Top Bottom