Forum Discussion
Show queue with data from WMS-system
Hi,
I'm having a problem building a report, which is going to live stream a view of queues in our production.
I want a table/Matrix for each date, which shows the info like below, with a hidden filter which shows priority 1 and 2 etc(See SQL data below).
Queues both have a Ready column and a Done column, see below.
Status 1 - Ready
Status 2 - Done
| Dispatch date: 10.05.2019 | |||||||
| Store | Pick lines | Queue1 | Queue2 | Queue3 | |||
| 1 2 … | 1 (50) 1 (37) | 0 (0) 0 (0) | 1 (50) 1 (37) | 0 (0) 0 (0) | 0 (0) 0 (0) | 0 (0) 0 (0) | 0 (0) 0 (0) |
| Dispatch date: 13.05.2019 | |||||||
| Store | Pick lines | Queue1 | Queue2 | Queue3 | |||
| 1 2 6 | 9 (282) 12 (344) 10 (272) | 5 (76) 9 (116) 8 (82) | 0 (0) 0 (0) 0 (0) | 3 (205) 3 (228) 2 (190) | 0 (0) 0 (0) 0 (0) | 1 (1) 0 (0) 0 (0) | 0 (0) 0 (0) 0 (0) |
How my data looks in SQL:
| Store | Queue1 | Queue2 | Queue3 | Status | orderno | Date | Pick lines | Priority |
| Store1 | 1 | NULL | NULL | Ready | 1234567 | 10.05.2019 | 16 | 1 |
| Store2 | NULL | 1 | NULL | Ready | 7654321 | 10.05.2019 | 54 | 2 |
| Store3 | NULL | NULL | 1 | Done | 987564 | 13.05.2019 | 3 | 3 |
| Store4 | 1 | NULL | NULL | Ready | 947613 | 15.05.2019 | 19 | 1 |
I have tried to do it with a table and a matrix, but with no luck.
4 Replies
Hi Anonymous ,
I cannot get the logic between your tables and excepted result. Could you please share a sample to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi Frank,
The data is just a 'imaginary' data, because of confidential data, so this is not an option, sorry.
I'll try to explain otherwise:
I need a table/matrix for each date with the 4 queues attached. F.x If I have a dispatach date 10.05.2019, I will need a table/matrix, which shows data for each store with a order no. the following date, sorted by pirority column.
F.x
If I have a dispatchdate the 14/5/19, this needs to be shown, sorted by pirority, lowest value on top(With a hidden filer, becuse the priority column needs to be hidden in the table/matrix). This needs to be shown, so the workers know which queue are the first to proceed with.
Dispatch date: 14/05/19 Store: Queue1: Queue2: Queue3: Queue4: Store4 1 NULL NULL NULL Store7 NULL 1 NULL NULL Data:
Short explanation of data:
A store can only have 1 order no. pr queue.
Store name Queue1 Queue2 Queue3 Queue4 Priority Status Order no. Rute no. Dispatchdate Store1 1 NULL NULL NULL 1904080400 Not ready 308956 Rute1 27/05/19 Store2 NULL 1 NULL NULL 1904080401 Not ready 308964 Rute2 26/05/19 Store3 NULL NULL 1 NULL 1904080401 Not ready 308964 Rute3 28/05/19 Store4 NULL 1 NULL NULL 1904080401 Not ready 308964 Rute1 14/05/19 Store5 NULL NULL 1 NULL 1904080401 Not ready 308964 Rute2 28/05/19 Store6 1 NULL NULL NULL 1904080402 Not ready 308961 Rute4 19/05/19 Store7 NULL 1 NULL NULL 1904080403 Not ready 308959 Rute3 14/05/19 Store8 NULL NULL 1 NULL 1904080403 Not ready 308959 Rute5 28/05/19 Hopes this gives you a better explanation?
Hello, DataJoe, I'm wondering if you find your own solution for this problem. I'm facing familiar issue right now, and maybe from 2019 you figured something...
