Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a next table
Table Purchase orders
Product,Ordernr, Qty, ETA
A,12345,10,20140615
A,12390,25,20140819
A,12455,50,20140720
B,12359,15,20140930
C,12300,20,20140509
C,12345,50,20140615
There are three Orders for Product A
There is one Order for Product B
There are two orders for Product C
Must be displayed in a array which is sorted on ETA
The o
Table Stock
Product, AFS
A,55
B,0
C,15
Tabel Product
Product Description,Usage
A,ProductA,40
B,ProductB,5
C,ProductC,10
We want this to have in a following matrix
Product | Description | AFS | PO Array1 Qty | PO# Array1 | PO Array1 Date | POT | PO Array2 QTY | PO# Array2 | PO Array2 Date | POT | `PO Array3 Qty | PO Array3 Date |
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | ProductA | 55 | 10 | 12345 | 20140615 | 25 | 50 | 12455 | 20140720 | 20 | 25 | 20140819 |
B | ProductB | 0 | 15 | 12359 | 20140930 | 0 | ||||||
C | ProductC | 15 | 20 | 12300 | 20140509 | 20 | 12345 | 20140615 | ||||
Can some please help me how to solve this.
See attached qvw
Hoi Gysbert,
Dit werkt !
Bedankt
Arthur