Hi - I would like to output only the latest date (data is updated every day with previous date and is cumulative). How would I do this?
Input:
Date | TPC | CPC | BAL |
9/1/2020 | ALL | ALL | 1191157 |
9/2/2020 | MC | AAA | 0 |
9/2/2020 | MC | ALA | 0 |
9/3/2020 | MC | BRW | 40500 |
9/4/2020 | MC | BST | 0 |
9/4/2020 | MC | BUS | 0 |
9/6/2020 | MC | CAQ | 0 |
9/8/2020 | MC | CCR | 0 |
9/8/2020 | MC | HDV | 0 |
9/8/2020 | MC | IT2 | 0 |
Output:
Date | TPC | CPC | BAL |
9/8/2020 | MC | CCR | 0 |
9/8/2020 | MC | HDV | 0 |
9/8/2020 | MC | IT2 | 0 |
Thanks!
Solved! Go to Solution.
Hi @jenner85 ,
Here is a workflow for the task.
Input : Table given by you
Output :
Workflow
Hope this helps : )
If this post helps you please mark it as solution. And give a like if you dont mind : )