Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Year. Product. Jvm
2020. Air Dom. 2000.
2020 . Air Intl. 1500.
2020. Hotel. 3500.
2021. Air Dom. 2500
2021. Air Intl. 2000
2021. Hotel. 3000
2022. Air Dom. 3000
2022. Air Intl. 1000
2022. Hotel. 2000
Identify which product’s Jvm is increasing every year and extract the records.
Hi
Try like below
Temp:
LOAD * INLINE [
Year,Product,Jvm
2020 , Air Dom , 2000
2020 , Air Intl, 1500
2020,Hotel, 3500
2021,Air Dom, 2500
2021 , Air Intl, 2000
2021, Hotel, 3000
2022, Air Dom,3000
2022 , Air Intl, 1000
2022 , Hotel, 2000
];
Load *, if(Product = Previous(Product), if(Jvm > Previous(Jvm), 1, 0),0) as Flag Resident Temp order by Product, Year;
DROP Table Temp;
Use Flag in the front end