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?