community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Selecting latest data based on time

ZahinOsman
8 - Asteroid
‎02-27-2023 06:41 AM

Hi,

 

I'm having trouble sorting for the latest data set. In the screenshot below, I have several "runs" which are identical, separated only by their "Submitted Time".

 

ZahinOsman_0-1677508296004.png

For example, under category "Right_Run++" and highlighted in yellow, there are 4 "AmericasClose_CSD_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile"
runs that have been run at different timings. This can be seen under category "Submitted Time" I wish to only retrieve the latest run, which is run at 2/27/2023 2:43

 

I have attached the full table below to make it easier. "AmericasClose_Flow_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile" (highlighted in green) is also run more than once, ideally the workflow would only retrieve the latest run as well

 

Run_DescriptionBatch_NameScheduleRegion CategoryUserSubmitted TimeProgressValuation DateRight_Run++
AmericasClose_CSD_1FIBMO_FX_Amer_CloseDailySingaporeFX Amer CoreSYSRNABORPDN12/24/2023 22:15FinishedFailed2/26/2023AmericasClose_CSD_1FIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_1F_HVAR
AmericasClose_CSD_OnsmileIBMO_FX_Amer_CloseDailySingaporeFX Main RiskSYSRNABORPDN12/24/2023 22:00FinishedFailed2/26/2023AmericasClose_CSD_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile
AmericasClose_CSD_OnsmileIBMO_FX_Amer_CloseDailySingaporeFX Main Riskx013818622/27/2023 1:30FinishedFailed2/26/2023AmericasClose_CSD_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile
AmericasClose_CSD_OnsmileIBMO_FX_Amer_CloseDailySingaporeFX Main Riskx013818622/27/2023 2:43FinishedFailed2/26/2023AmericasClose_CSD_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile
AmericasClose_CSD_OnsmileIBMO_FX_Amer_CloseDailySingaporeFX Main Riskx01437873_aps2/27/2023 2:06FinishedFailed2/26/2023AmericasClose_CSD_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile
AmericasClose_Flow_1f_HvarIBMO_FX_Amer_CloseDailySingaporeFX Amer CoreSYSFXDERIEPDN2/24/2023 22:00FinishedFailed2/26/2023AmericasClose_Flow_1f_HvarIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_1f_HVAR
AmericasClose_Flow_1f_HvarIBMO_FX_Amer_CloseDailySingaporeFX Amer Corex012796002/24/2023 22:15FinishedSuccess2/26/2023AmericasClose_Flow_1f_HvarIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_1f_HVAR
AmericasClose_Flow_1f_Hvar_NDFIBMO_FX_Amer_CloseDailySingaporeFX Amer CoreSYSFXDERIEPDN2/24/2023 22:00FinishedSuccess2/26/2023AmericasClose_Flow_1f_Hvar_NDFIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_1F_HVAR_NDF
AmericasClose_Flow_OnsmileIBMO_FX_Amer_CloseDailySingaporeFX Main RiskSYSFXDERIEPDN2/24/2023 22:00FinishedFailed2/26/2023AmericasClose_Flow_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile
AmericasClose_Flow_OnsmileIBMO_FX_Amer_CloseDailySingaporeFX Main Riskx012796002/24/2023 22:18FinishedSuccess2/26/2023AmericasClose_Flow_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile
AmericasClose_Flow_Onsmile_NDFIBMO_FX_Amer_CloseDailySingaporeFX Main RiskSYSFXDERIEPDN2/24/2023 22:00FinishedSuccess2/26/2023AmericasClose_Flow_Onsmile_NDFIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDF
CSD_ClientVal_OnsmileIBMO_FX_Amer_CloseDailySingaporeFX Main RiskSYSRNABORPDN12/24/2023 22:30FinishedSuccess2/26/2023CSD_ClientVal_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreclientvalNewYorkClose/RunDefinition/EOD_FXO/CSD_ClientVal_Onsmile
CSD_Spotladder20pcIBMO_FX_Amer_CloseDailySingaporeFX ScenariosSYSFXDERIEPDN2/24/2023 22:16FinishedFailed2/26/2023CSD_Spotladder20pcIBMO_FX_Amer_Closeamericascloseonsmile_spotladder20pcNewYorkClose/RunDefinition/EOD_FXO/CSD_Spotladder20pc
CSD_Spotladder20pcIBMO_FX_Amer_CloseDailySingaporeFX Scenariosx013818622/27/2023 2:45FinishedFailed2/26/2023CSD_Spotladder20pcIBMO_FX_Amer_Closeamericascloseonsmile_spotladder20pcNewYorkClose/RunDefinition/EOD_FXO/CSD_Spotladder20pc
Flow_Spotladder20pcIBMO_FX_Amer_CloseDailySingaporeFX ScenariosSYSFXDERIEPDN2/24/2023 22:16FinishedFailed2/26/2023Flow_Spotladder20pcIBMO_FX_Amer_Closeamericascloseonsmile_spotladder20pcNewYorkClose/RunDefinition/EOD_FXO/Flow_Spotladder20pc
Flow_Spotladder20pcIBMO_FX_Amer_CloseDailySingaporeFX Scenariosx013818622/27/2023 2:49FinishedSuccess2/26/2023Flow_Spotladder20pcIBMO_FX_Amer_Closeamericascloseonsmile_spotladder20pcNewYorkClose/RunDefinition/EOD_FXO/Flow_Spotladder20pc
LondonClose_LDB_PV_COD_Onsmile_TriadIBMO_FX_Amer_CloseDailySingaporeFX RevalSYSFXDERIEPDN2/24/2023 22:00FinishedSuccess2/26/2023LondonClose_LDB_PV_COD_Onsmile_TriadIBMO_FX_Amer_Closelondoncloseonsmile_nac_cod_postLondonClose/RunDefinition/EOD_FXO/LDB_PV_COD_Onsmile

 

Thanks!

 

 

Reply
0 Likes
1 REPLY 1
binu_acs
21 - Polaris
‎02-27-2023 07:27 AM

@ZahinOsman One way of doing this by converting the Submitted Time to DateTime format and sorting descending order and select the first record using a sample tool

 

binuacs_0-1677511591537.png

 

LatestRecord_270223.yxmd
Reply
Community Live
Getting Started as a License Admin
Labels
Top Solution Authors
View All