How do I load only first occurrence of field?

[#1]

Dear qlik community, i'd be grateful if you could help me with the following issue.

I have the following source file, which I ordered by customer and payment terms

So I want to load customer only once, together with minimum payment terms

Source file - already ordered as shown and resident
Customer	payment_terms
AAA	30
AAA	60
BBB	30
BBB	60
BBB	90
I only want to load
Customer	payment_terms
AAA	30
BBB	30

Thank you in advance

[maxgro · Accepted solution]

with not exists

replace load inline with load from your source

test:

load * where not exists(Customer);

load * inline [

Customer, payment_terms

AAA, 30

AAA, 60

BBB, 30

BBB, 60

BBB, 90

];

[anbu1984]

test:

load Customer,Min(payment_terms) As payment_terms Group by Customer;

load * inline [

Customer, payment_terms

AAA, 30

AAA, 60

BBB, 30

BBB, 60

BBB, 90

];