Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Is there any expression in Data Load Editor where I can select one of doubled values?
User | ORDER ID | DATE | QTY |
AUTO | 103459 | 21-8-2018 | 2 |
XYZ | 103459 | 21-8-2018 | 2 |
AUTO | 103448 | 21-8-2018 | 2 |
AUTO | 103463 | 21-8-2018 | 1 |
XYZ | 103789 | 21-8-2018 | 5 |
AUTO | 101235 | 21-8-2018 | 3 |
XYZ | 108531 | 21-8-2018 | 1 |
AUTO | 106941 | 21-8-2018 | 4 |
XYZ | 102648 | 21-8-2018 | 8 |
In this case I need only amount of unites done by USER: XYZ.
So In case where two users appears for the same order I need last occurred transaction.
Greetings
P.Rybacki
MyData:
LOAD * FROM ...somewhere... WHERE User <> 'AUTO';
CONCATENATE (MyDate)
LOAD * FROM ...somewhere... WHERE Not Exists([Order ID]);
Afaict they're all the last occurred transaction since they all have the same DATE value. So how should QS know which is the last one?
Hi Gysbert,
I haven't specify my question.
Doesn't matter when occurred. what I need is, every time when for the same order two users appears I need not AUTO.
When you load the data you can add a WHERE clause to the load statement to skip all the records where the user is AUTO:
LOAD * FROM ...somewhere... WHERE User <> 'AUTO';
Hi,
Please look the table which I pasted. The orders are done or AUTO or XYZ, so I also need AUTO.
This exception is when AUTO (machine) packed order but it was wrong, so USER: XYZ came and fixed package. Than I need only XYZ. For rest of the order AUTO is needed as soon as Will be not fixed by human (XYZ)
MyData:
LOAD * FROM ...somewhere... WHERE User <> 'AUTO';
CONCATENATE (MyDate)
LOAD * FROM ...somewhere... WHERE Not Exists([Order ID]);
Thanks!