Extract last day of every month

[ecabanas]

Hi guys,

I have a table and I want to create a table and extract only the last day of month for every month,

What do you think?

Many thank's

[sunny_talwar]

In the script? May be this after your load statement:

Right Join (AboveTable)

LOAD Date(Floor(MonthEnd(created))) as created

Resident AboveTable;

[settu_periasamy]

May be like this.. after loading your first table

Monthend_Table:

LOAD created,ItemId,stock

Resident Firsttable where created=MonthEnd (created);

[ecabanas]

Hi Settu,

The problem is that your script only takes the last month, not the last date of the 3 months

many thank's

[ecabanas]

Hi Sunny,

Here we are again 🙂

the problem is I want to created a sepparated table to know the end month stock position, why right join?

many thank's

[sunny_talwar]

Oh so you want all data in your application, but just restrict it in one chart on the front end?

[#7]

Something like this

A:

Load

Created,

Item ID,

stock

From

[xxxxxxxxx.xlsx];

left Join (A)

LOAD

Item ID,

max(Created) as [Maxdate in the Month]

Resident  A

group by Item ID ,Month(Created);

[sunny_talwar]

Something like this?

[ecabanas]

yes Sunny!!!!that's it!!

[sunny_talwar]

Awesome,

If you got what you needed, would you mind closing this thread down by marking correct and helpful answers.

Best,

Sunny