Alexey,
Could you go more into detail on how you use Power Query with Winshuttle? When I try build in Power Query into my working excel file I get an error message saying the file is in read only mode and will not allow me to run Winshuttle. I have also tried building a power query in its own excel work book and bring back the data from that workbook and get the same issue. Any quick feedback would be helpful to try to complete my past due deadline.
------------------------------
Benjamin Kielas
Generac Power Systems, Inc.
WAUKESHA WI
------------------------------
Original Message:
Sent: 03-20-2023 03:58
From: Alexey Skotnikov
Subject: AFKO Extract table by date vs order number
Assuming you're using Query to extract. There are very limited options on sorting, filtering and joins that Winshuttle provide, so it will always be extracted sorted by primary key. You may use PowerQuery in Excel to transform data as you need once extracted.
------------------------------
Alexey Skotnikov
Abbott Rapid Diagnostics AS
Original Message:
Sent: 03-19-2023 13:28
From: Benjamin Kielas
Subject: AFKO Extract table by date vs order number
When extracting the AFKO table data as is extract pulls by oldest order number. Is there a way to extract by oldest date and not by lowest order number?
When extracting using COOIS the report comes out with oldest date vs oldest order.
------------------------------
Benjamin Kielas
Generac Power Systems, Inc.
WAUKESHA WI
------------------------------