Forum Discussion

JakeandSnake's avatar
JakeandSnake
Frequent Visitor
5 years ago
Solved

To Show the latest Status based on Columns Value

Hi Experts,   I have one table as below: Conditions: 1. In reality, I have thousands of projects. More than 500K rows.  2. I have a lot of steps, could be 30 steps columns.   Expectation...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey JakeandSnake ,

     

    for the example you provided it worked 😉

    Rename the columns to give the step an order and put the number first, then it will work:

     

    And the result:

     

    When you have more than 10 columns make sure you have the same amount of numbers at the beginning everywhere:

     

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
JakeandSnake's avatar
JakeandSnake
Frequent Visitor
5 years ago

Hi selimovd ,

 

Thanks for your advice. 

I assume your last step is to group by the MAX of the "Attribute" column. 

And I guess it works because the status columns are named sequentially " Step 1", Step 2"...

However, when I tried mine, which status columns are totally words like "Step ABC", "Step BCD"...The results were not accurate. Any idea? 

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey JakeandSnake ,

 

for the example you provided it worked 😉

Rename the columns to give the step an order and put the number first, then it will work:

 

And the result:

 

When you have more than 10 columns make sure you have the same amount of numbers at the beginning everywhere:

 

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • JakeandSnake's avatar
    JakeandSnake
    Frequent Visitor
    5 years ago

    Thanks~ It works for me now!