Selecting one of the doubled values

[przemyslaw_r]

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

[Gysbert_Wassenaar]

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?

[przemyslaw_r]

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.

[Gysbert_Wassenaar]

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';

[przemyslaw_r]

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)

[Gysbert_Wassenaar · Accepted solution]

MyData:

LOAD * FROM ...somewhere... WHERE User <> 'AUTO';

CONCATENATE (MyDate)

LOAD * FROM ...somewhere... WHERE Not Exists([Order ID]);

[przemyslaw_r]

Thanks!