Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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
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;
Great !!
It works. Thanks for your help