Again - a simple exclusion required

[#1]

Hi

I seem to be running into simple problems - that for me seem difficult to resolve

Here I am reading a list of Released Batches from a transaction table

The Batch may be released all in one go on the one day - or partially over several days - or partially during the same day

All I need to report is the First Date is was released

The input file looks something like

Batch#      Release-Date  Release-Qty

A1               01/10/2015          100

A1               01/10/2015          200

A2               02/10/2015            50

A2               03/10/2015            60

A5               06/10/2015          300

All I am after are the first release details as part of a chart

Batch#     First-Release

A1               01/10/2015

A2               02/10/2015

A5               06/10/2015

How is this best accomplished?

[#2]

See attached, used Min (Date([Release-Date]))

[Kushal_Chawda]

Create straight table

Dimensions:

Batch#

Expression:

=aggr(date(min([First-Release]),'DD/MM/YYYY'),Batch#)

[tresesco]

With Batch# in dimension, aggr() would be redundant and should be avoided.

     Simple: =Date(Min ([Release-Date]))

should be enough.

[tamilarasu]

Hi David,

    Is there any chance that the release quantity is high (100 - 1st release and 50 -2nd release) at first release.? If not, you can try the above solutions.

[NareshGuntur · Accepted solution]

This should simply do the trick while loading.

"not exists" will load only the values which are not already loaded.

Also have the qvw attached.

load * inline [

Batch#,      Release-Date,  Release-Qty

A1,              01/10/2015,          100

A1,              01/10/2015,          200

A2,              02/10/2015,            50

A2,              03/10/2015,            60

A5,              06/10/2015,          300

]

Where not Exists(Batch#);