试图表数据 [英] Trying to table data
问题描述
我必须放置大量数据。
我每周两次从16家商店获得两个库存清单。
我将这些数据分成两部分方式。
我这样做是通过将库存清单与300种最畅销款式的清单进行比较。
目前，我输入一个excel中的库存数据列表，然后将项目分别组织到列中的销售数据列表中。前25种款式，50,100,200,300。
当我完成后，我在前25种款式中有一定数量的商品，在前50款中有一定数量的商品，以及等等。我对列进行颜色编码并记下列表中每个类别的数量和百分比。
我一直在尝试创建关系，以便在Access和Filemaker专家中对数据进行排序。
到目前为止，我只能组织数据，但我想要的格式之外。
I have to Table large amounts of Data.
I get two inventory lists twice a week from 16 stores.
I sort this data in two ways.
I do this by comparing an inventory list to a list of 300 of the best selling styles.
Currently, I input one list of inventory data in excel and then organize the items respectively to a sales data list in columns. Top 25 styles, 50, 100, 200, 300.
When I am finished, I have a certain amount of items in the top 25 styles, a certain amount in top 50, and so on. I color code the columns and write down the quantities and percentage of each category in the list..
I have been trying to create relationships that would sort the data in Access and in Filemaker pro.
So far, I have only been able to organize data in groups but outside of the format I am trying to get.
推荐答案
我必须表示大量数据。
我每周两次从16家商店获得两个库存清单。 />
我用两种方式对这些数据进行排序。
我通过将库存清单与300种最畅销款式的清单进行比较来做到这一点。
目前，我在excel中输入一个库存数据列表，然后将这些项目分别组织到列中的销售数据列表中。前25种款式，50,100,200,300。
当我完成后，我在前25种款式中有一定数量的商品，在前50款中有一定数量的商品，以及等等。我对列进行颜色编码并记下列表中每个类别的数量和百分比。
我一直在尝试创建关系，以便在Access和Filemaker专家中对数据进行排序。
到目前为止，我只能组织数据，但不是我想要的格式。
I have to Table large amounts of Data.
I get two inventory lists twice a week from 16 stores.
I sort this data in two ways.
I do this by comparing an inventory list to a list of 300 of the best selling styles.
Currently, I input one list of inventory data in excel and then organize the items respectively to a sales data list in columns. Top 25 styles, 50, 100, 200, 300.
When I am finished, I have a certain amount of items in the top 25 styles, a certain amount in top 50, and so on. I color code the columns and write down the quantities and percentage of each category in the list..
I have been trying to create relationships that would sort the data in Access and in Filemaker pro.
So far, I have only been able to organize data in groups but outside of the format I am trying to get.
查看本教程，看看是否有帮助。
规范化和表格结构
玛丽
有意义......
所以看起来我有多对多的关系。
我以为我有1对多的关系。
销售数据是desc1，这是样式代码（文字和数字......将会这是一个问题？），desc2（项目的完整描述，我在建立关系时没有使用它），以及排名，这是1-300的级别。
我已加入关系数据库中前25个，50个，100个，200个和前300个列的排名列。
我也加入了清单数据中的''styles''并将其加入desc1。
那么这对我的数据有什么影响？
似乎我只能将排名排在库存项目的一边，而不是填写我标记为前25名，前50名，前100名的栏中的方框，前200名，前300名。
所以...这就是我被困住的地方。
我感谢你的帮助。
that made sense...
so It seems like I have a many to many relationship.
I thought I had a 1 to many relationship.
The sales data is in desc1 which is the style code (text and number... will this be a problem?), desc2 (the full description of item, I didnt use it when I made relationships), and ''rank'' which was a level from 1-300.
I ''joined'' the ''rank'' column to the top 25, 50, 100, 200, and top 300 columns in the relationship database.
I also joined ''styles'' in the inventory data and joined it to desc1.
So what does this do to my data?
It seemed I was only able to make the ranks line up on the side of the inventory items, not fill in the boxes in the columns I labeled top 25, top 50, top 100, top 200, top 300.
so... this is where I am stuck.
I appreciate your help.
在多对多关系中，您通常会有一个连接表，其中包含其他两个表的主键。我跟你的结构有问题。你可以发布所涉及的两个表的元数据吗。
这是一个如何发布表元数据的例子：
表名= tblBookings
In a many to many relationship you would normally have a join table which would have the primary keys of the other two tables. I''m having problems following your structure. Can you post the metadata of the two tables involved.
Here is an example of how to post table MetaData :
Table Name=tblBookings
这篇关于试图表数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
