Forum Discussion
Show queue with data from WMS-system
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?