First Value in the table

[surendraj]

Hi All,

in the below table, i need to capture the first value of the price for every model and month_year in a new field. (need in script level)

For Example:

for a model , if we have price for july2017 then we consider that price . if  july2017 has no price then we capture the price for aug2017  and so on ..

[sunny_talwar]

Can you share a sample or may be sample data in an Excel file.... or share the script you have been trying

[stabben23]

Its half because of the Group by Crawlwer, Manufacturer and Category.

I'll think Model will be enough

[surendraj]

even we keep only model also.. i m getting half values

[stabben23]

Have you tried this?

MinPrice:

LOAD

Model,

date(min(MonthLastDay),'DD-MM-YYY') as Min_MonthYear,

firstsortedvalue(Price, MonthLastDay) as Min_Price

Resident Your table

Group by Model;

[surendraj]

can u tell me ur mail id .,. i shall send it ..

[surendraj]

no data coming into min_price .