Show only 1 Labor value per project.
![satishkurra](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar6.png)
satishkurra
Registered Posts: 10 ✭✭✭
Hi Team
Trying to achieve the result by joining and then applying the window function to get Labor only in 1 record for project instead of all records.
Attached is the data and the current o/p vs desired output
Please help me in getting this answered to derive the solution
Operating system used: Browser
Best Answer
-
Hi All
Able to achieve this using window function by selecting row number and once done, applied formula to get the data to show only 1 time for project as below
if(rownumber==1,Labor,0)
It worked. Thanks