Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
JoannaM
Contributor III

find next row and go to one specific column

Hi all

I have an operation plan (production) and I have to find the next operation to be done.

I have found the max_date and therefore found the last operation which has been done.

Now I need to show the next operation step. The data is the next row and then the colum where the work center is located.

How can I get there?

Thanks for the Input.

Best regards, Joanna

1 Solution

Accepted Solutions
Sammy_AK
Creator II

if the table looks exactly how it is, i have an alternate approach to this solution. instead of looking for last available date, i will look for blank values in column "operation plan" and look for minimum step, which is nothing but the next step and the expression: only({<step = {$(=Min({<operation_plan={''}>}step))}>}operation_date).  

View solution in original post

4 Replies
Sammy_AK
Creator II

you can use set analysis to find the details of next column. lets say there are 2 columns Plan_Production and Next_operation.

to find the las operation you have applied Max(Plan_Production) to get the max date, similarly you can apply set analysis to find the next operation date: =Only({<Plan_Production = {"=Max(Plan_Production)"}>}Next_operation)

hope this works... if not, can you post some sample table with data or QVF file ?

JoannaM
Contributor III
Author

Hi

Thank you for your answer.

I have a picture below what I am looking for exactly.

I have found the last date (max date) and the last step in the production (work center) but I need to show the next step (work center).

Yellow mark is what I have and the green mark is what I need to see.

JoannaM_1-1622099960013.png

Thank you so much for your help.

BR, Joanna

Sammy_AK
Creator II

if the table looks exactly how it is, i have an alternate approach to this solution. instead of looking for last available date, i will look for blank values in column "operation plan" and look for minimum step, which is nothing but the next step and the expression: only({<step = {$(=Min({<operation_plan={''}>}step))}>}operation_date).  

JoannaM
Contributor III
Author

Thank you so much! Worked perfectly.