Hello, I have the three following tables:
| Material |
Length Buckets |
Average Length Buckets |
| ID |
|
|
| Number of Pieces |
|
|
| Average Length |
|
Average Length |
| Length |
Length |
|
| |
Length From |
Length From |
| |
Length To |
Length To |
| |
Length Bucket |
Length Bucket |
The columns with the same names are identical, and should be linked.
The Length Bucket columns have been added as below:
[Length Buckets]:
LOAD * Inline
[
Length From, Length To, Length Bucket
0, 2.49, 0-2.5
2.5, 4.99, 2.5-5
5, 1E6, 5+
];
Inner Join IntervalMatch([Length])
LOAD [Length From], [Length To]
Resident [Length Buckets];
[Average Length Buckets]:
LOAD * Inline
[
Length From, Length To, Length Bucket
0, 2.49, 0-2.5
2.5, 4.99, 2.5-5
5, 1E6, 5+
];
Inner Join IntervalMatch([Average Length])
LOAD [Length From], [Length To]
Resident [Average Length Buckets];
How can I avoid the synthetic key created? How can I create a barchart that shows the [Length Buckets] on the X-axis. The y-axis are a sum of the weight of the material. If the material has a value > 0 for Number of Pieces, the value for Length Bucket is taken from [Length Buckets] and otherwise, [Average Length Buckets]
Any help appreciated thanks 🙂
