Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
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
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
binuacs
20 - Arcturus
‎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
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels