Dated price list

[Anonymous]

Dear all,

I've a dated price list and for each item, I've to consider the latest starting dates (see excel file in attachment)

How can I solve this problem ?

I'm trying without success for a long time...

Help please

Thanks in advance for your support

[sunny_talwar]

Two questions, what do you expect to see? Is this something you want to handle in script or front end of the application or you don't care

[Anonymous]

In this case, It' something I want to handle into the script. At the end of the loading, I should have only the yellow lines (see excel file) into my table

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD ItmeNr,

    Company,

    Price,

    From,

    To

FROM

PricesOnDate.xlsx

(ooxml, embedded labels, table is Foglio1);

Right Join(Table)

LOAD ItmeNr,

  Max(From) as From

Resident Table

Group By ItmeNr;

[Anonymous]

Great !!

It works. Thanks for your help