Combining 2 data sources(excel) into 1 output

Question

Hi guys,

I have 2 data sources that I need to pull data from and combine/compare in order to form an output file.

In Data set 1, I have pasted a sample below of the format and table headers;

In Data set 2, I have included the sample below;

In the Final output file, I will need the following fields (highlighted in bold) to be populated from the 2 data sources (Data set 1 and Data set 2). In the complete Data set 1 file, there will be runs that are similar, denoted by "Custom:". These runs are the same.

The purpose of the output file is to compare to see which values are missing between the 2 excel sheets, as seen in the fields;

Run Today?

Initial Run Status

The full final output table should look like this;

Run_DescriptionBatch_NameRun PathLabelFilter_PrefixFilter_SuffixScheduleHol CalendarRegion CategoryRun++Run Today?Initial Run StatusRun countRun Deleted?AmericasClose_CSD_1FIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/CSD_1F_HVARamericasclose1f1f_pure_coreDaily SingaporeFX Amer CoreAmericasClose_CSD_1FIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_1F_HVARTRUEMissing0NOAmericasClose_Flow_1f_HvarIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/Flow_1F_HVARamericasclose1f_pure1f_pure_coreDaily SingaporeFX Amer CoreAmericasClose_Flow_1f_HvarIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_1F_HVARTRUEMissing0NOAmericasClose_Flow_1f_Hvar_NDFIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/Flow_1F_HVAR_NDFamericasclose1f1f_pure_coreDaily SingaporeFX Amer CoreAmericasClose_Flow_1f_Hvar_NDFIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_1F_HVAR_NDFTRUEMissing0NOCVAR_Base_NonLDIBMO_FX_Amer_CloseOfficial_EOD/RunDefinition/CVAR/CVAR_Base_NonLDbarx_americascloseonsmileonsmile_MurexRecDaily SingaporeFX CVARCVAR_Base_NonLDIBMO_FX_Amer_Closebarx_americascloseonsmile_MurexRecOfficial_EOD/RunDefinition/CVAR/CVAR_Base_NonLDTRUEMissing0NOCVAR_Base_LDIBMO_FX_Amer_CloseOfficial_EOD/RunDefinition/CVAR/CVAR_Base_LDbarx_americascloseonsmileonsmile_MurexRecDaily SingaporeFX CVARCVAR_Base_LDIBMO_FX_Amer_Closebarx_americascloseonsmile_MurexRecOfficial_EOD/RunDefinition/CVAR/CVAR_Base_LDTRUEMissing0NOCSD_ClientVal_OnsmileIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/CSD_ClientVal_Onsmileamericascloseonsmileonsmile_coreclientvalDaily SingaporeFX Main RiskCSD_ClientVal_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreclientvalNewYorkClose/RunDefinition/EOD_FXO/CSD_ClientVal_OnsmileTRUEMissing0NOAmericasClose_CSD_OnsmileIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmileamericascloseonsmileonsmile_coreDaily SingaporeFX Main RiskAmericasClose_CSD_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_OnsmileTRUEMissing0NOAmericasClose_Flow_OnsmileIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmileamericascloseonsmileonsmile_coreDaily SingaporeFX Main RiskAmericasClose_Flow_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_OnsmileTRUEMissing0NOAmericasClose_Flow_Onsmile_NDFIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDFamericascloseonsmileonsmile_coreDaily SingaporeFX Main RiskAmericasClose_Flow_Onsmile_NDFIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDFTRUEMissing0NOLondonClose_LDB_PV_COD_Onsmile_TriadIBMO_FX_Amer_CloseLondonclose/RunDefinition/EOD_FXO/LDB_PV_COD_Onsmilelondoncloseonsmileonsmile_nac_cod_postDaily SingaporeFX RevalLondonClose_LDB_PV_COD_Onsmile_TriadIBMO_FX_Amer_Closelondoncloseonsmile_nac_cod_postLondonclose/RunDefinition/EOD_FXO/LDB_PV_COD_OnsmileTRUEMissing0NOCSD_Spotladder20pcIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/CSD_Spotladder20pcamericascloseonsmileonsmile_spotladder20pcDaily SingaporeFX ScenariosCSD_Spotladder20pcIBMO_FX_Amer_Closeamericascloseonsmile_spotladder20pcNewYorkClose/RunDefinition/EOD_FXO/CSD_Spotladder20pcTRUEMissing0NOFlow_Spotladder20pcIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Spotladder20pcamericascloseonsmileonsmile_spotladder20pcDaily SingaporeFX ScenariosFlow_Spotladder20pcIBMO_FX_Amer_Closeamericascloseonsmile_spotladder20pcNewYorkClose/RunDefinition/EOD_FXO/Flow_Spotladder20pcTRUEMissing0NO

I have an existing workflow that accomplishes half of what the table generates above. Could this be improved?

I have attached my 2 data sources (Data set 1 and Data set 2) and my existing workflow. Any help would be appreciated!

Best regards,

Zahin

Workflow.yxmd

ZahinOsman · Answer

Hi @Emmanuel_G

Data set 2

NoRun_DescriptionBatch_NameRun PathLabelFilter_PrefixFilter_SuffixScheduleHol CalendarRegion Category1CSD_OnsmileIBMO_FX_AmerFlow_AmendsNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmileamericascloseonsmileonsmile_amendsDaily SingaporeFX Amends2Flow_OnsmileIBMO_FX_AmerFlow_AmendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmileamericascloseonsmileonsmile_amendsDaily SingaporeFX Amends3Flow_Onsmile_NDFIBMO_FX_AmerFlow_AmendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDFamericascloseonsmileonsmile_amendsDaily SingaporeFX Amends123CSD_ClientVal_OnsmileIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/CSD_ClientVal_Onsmileamericascloseonsmileonsmile_coreclientvalDaily SingaporeFX Main Risk124AmericasClose_CSD_OnsmileIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmileamericascloseonsmileonsmile_coreDaily SingaporeFX Main Risk125AmericasClose_Flow_OnsmileIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmileamericascloseonsmileonsmile_coreDaily SingaporeFX Main Risk126AmericasClose_Flow_Onsmile_NDFIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDFamericascloseonsmileonsmile_coreDaily SingaporeFX Main Risk194LondonClose_LDB_PV_COD_Onsmile_TriadIBMO_FX_Amer_CloseLondonclose/RunDefinition/EOD_FXO/LDB_PV_COD_Onsmilelondoncloseonsmileonsmile_nac_cod_postDaily SingaporeFX Reval195CSD_Onsmile_OpenIBMO_FX_Amer_OpenNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_Openamericascloseonsmileonsmile_openDaily SingaporeFX Reval196Flow_Onsmile_OpenIBMO_FX_Amer_OpenNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Openamericascloseonsmileonsmile_openDaily SingaporeFX Reval197Flow_Onsmile_Open_NDFIBMO_FX_Amer_OpenNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Open_NDFamericascloseonsmileonsmile_openDaily SingaporeFX Reval202CSD_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_RevalOpentoCloseamericascloseonsmileonsmile_revalDaily SingaporeFX Reval203Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoCloseamericascloseonsmileonsmile_revalDaily SingaporeFX Reval204Flow_Onsmile_RevalOpentoClose_NDFIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose_NDFamericascloseonsmileonsmile_revalDaily SingaporeFX Reval205CSD_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_RevalOpentoCloseamericascloseonsmileonsmile_reval_fxspotDaily SingaporeFX Reval206Flow_Onsmile_RevalOpentoClose_NDFIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose_NDFamericascloseonsmileonsmile_reval_fxspotDaily SingaporeFX Reval207Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoCloseamericascloseonsmileonsmile_reval_fxspotDaily SingaporeFX Reval

ZahinOsman · Answer

Hi @Emmanuel_G

Data set 1

NameBatch NameUserSubmitted TimeCompleted TimeProgress# Live# TradesWarning CountTotal Error CountLabelFilterRun PathValuation DateRun IDCustom:Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_Revalx013818629/5/20229/5/2022FinishedSuccess2270americascloseonsmile_reval_fxspotNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose9/2/20225f099913-7827-4bd0-aa5c-732822c33d41Custom:Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_Revalx013818629/5/20229/5/2022FinishedSuccess2270americascloseonsmile_revalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose9/2/2022b5e5a984-da22-4bac-ba5c-d55aeb2899faCustom:NewYorkClose/EOD_FXO/Flow_Onsmile_PnlcloseIBMO_FX_Amer_PnLClosex013818629/5/20229/5/2022FinishedSuccess101650americascloseonsmile_pnlcloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Pnlclose9/2/2022316b0729-57f9-4ea7-9853-0e98bc6948feCustom:Flow_Onsmile_OpenIBMO_FX_Amer_Openx013818629/5/20229/5/2022FinishedSuccess182450americascloseonsmile_openNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Open9/2/2022a9748b2b-4d75-4ceb-a535-ac10e66d327fCustom:Flow_OnsmileIBMO_FX_AmerFlow_Amendsx013818629/5/20229/5/2022FinishedSuccess101650americascloseonsmile_amendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile9/2/2022b370a984-59d5-4127-bb72-27bdcaea2db7Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalSYSRNABORPDN19/2/20229/2/2022FinishedFailed6293796231551americascloseonsmile_revalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose9/2/2022fef46e8c-0f4f-43d8-abbe-f6a1cb8e6ee0Flow_Onsmile_RevalOpentoClose_NDFIBMO_FX_Amer_RevalSYSRNABORPDN19/2/20229/2/2022FinishedSuccess0130americascloseonsmile_reval_fxspotNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose_NDF9/2/202245458b94-2110-4d63-89eb-be77ecfc60bcCSD_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalSYSRNABORPDN19/2/20229/2/2022FinishedSuccess479409030americascloseonsmile_reval_fxspotNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_RevalOpentoClose9/2/20228a14a8ec-95d3-4698-938b-a4982ae1932fCSD_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalSYSRNABORPDN19/2/20229/2/2022FinishedSuccess479409030americascloseonsmile_revalNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_RevalOpentoClose9/2/2022a93d6b55-9f06-4955-a85c-8be49dc90f5dFlow_Onsmile_RevalOpentoClose_NDFIBMO_FX_Amer_RevalSYSRNABORPDN19/2/20229/2/2022FinishedSuccess0130americascloseonsmile_revalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose_NDF9/2/202208aecebe-a30a-4c41-bc20-6b9601531e41NewYorkClose/EOD_FXO/Flow_Onsmile_pnlclose_NDFIBMO_FX_Amer_PnLCloseSYSRNABORPDN19/2/20229/2/2022FinishedSuccess0110americascloseonsmile_pnlcloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_pnlclose_NDF9/2/202210b89615-6612-4869-b788-e49a239e0685Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalSYSRNABORPDN19/2/20229/2/2022FinishedFailed6293796231551americascloseonsmile_reval_fxspotNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose9/2/202248a52def-e2c1-4ce8-9d26-5d5095252eddNewYorkClose/EOD_FXO/CSD_Onsmile_pnlcloseIBMO_FX_Amer_PnLCloseSYSRNABORPDN19/2/20229/2/2022FinishedSuccess479409010americascloseonsmile_pnlcloseNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_pnlclose9/2/202279f10c86-fc2a-4259-9f71-db3a282c3e65NewYorkClose/EOD_FXO/Flow_Onsmile_PnlcloseIBMO_FX_Amer_PnLCloseSYSRNABORPDN19/2/20229/2/2022FinishedFailed6293796231546americascloseonsmile_pnlcloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Pnlclose9/2/202256e396f7-0185-41fd-a71e-1eb5cfca6323Custom:AmericasClose_Flow_OnsmileIBMO_FX_Amer_CloseX013260909/2/20229/2/2022FinishedSuccess121250americascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile9/2/20221bab4e50-d5dc-4317-8c25-c170dc3440b6CSD_ClientVal_OnsmileIBMO_FX_Amer_CloseSYSRNABORPDN19/2/20229/2/2022FinishedSuccess184510americascloseonsmile_coreclientvalNewYorkClose/RunDefinition/EOD_FXO/CSD_ClientVal_Onsmile9/2/202234e41450-01b9-41ab-a387-8c5bd27b2f69AmericasClose_CSD_OnsmileIBMO_FX_Amer_CloseSYSRNABORPDN19/2/20229/2/2022FinishedSuccess479409210americascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile9/2/20228e125371-1488-4588-b17b-e55b6ce1d7a3CSD_OnsmileIBMO_FX_AmerFlow_AmendsSYSFXDERIEPDN9/2/20229/2/2022FinishedSuccess4610americascloseonsmile_amendsNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile9/2/2022451271b5-c8cc-47d3-899a-c5f9316f742aFlow_Onsmile_NDFIBMO_FX_AmerFlow_AmendsSYSFXDERIEPDN9/2/20229/2/2022FinishedSuccess0110americascloseonsmile_amendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDF9/2/202284dde59b-d5c9-4766-9dba-700799b9173bLondonClose_LDB_PV_COD_Onsmile_TriadIBMO_FX_Amer_CloseSYSFXDERIEPDN9/2/20229/2/2022FinishedSuccess444420londoncloseonsmile_nac_cod_postLondonClose/RunDefinition/EOD_FXO/LDB_PV_COD_Onsmile9/2/20228f0785f4-e3be-4331-93d0-b50ade30f91dFlow_OnsmileIBMO_FX_AmerFlow_AmendsSYSFXDERIEPDN9/2/20229/2/2022FinishedFailed3133428896americascloseonsmile_amendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile9/2/202265faaae8-5088-4aa1-84f8-70ec813b74c3AmericasClose_Flow_OnsmileIBMO_FX_Amer_CloseSYSFXDERIEPDN9/2/20229/2/2022FinishedFailed6238497530541americascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile9/2/2022ca7709e3-6834-4801-a741-c1e09cb36e5bAmericasClose_Flow_Onsmile_NDFIBMO_FX_Amer_CloseSYSFXDERIEPDN9/2/20229/2/2022FinishedSuccess0110americascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDF9/2/20228419eaf8-8356-417e-892a-98b0ef2a7702Flow_Onsmile_Open_NDFIBMO_FX_Amer_OpenSYSRNABORPDN19/2/20229/2/2022FinishedSuccess0110americascloseonsmile_openNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Open_NDF9/2/202202b65c13-717f-4948-9c5e-e553c91e61d6CSD_Onsmile_OpenIBMO_FX_Amer_OpenSYSRNABORPDN19/2/20229/2/2022FinishedSuccess479409010americascloseonsmile_openNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_Open9/2/2022ca91fdcd-6276-488d-b511-04d6eab38449Flow_Onsmile_OpenIBMO_FX_Amer_OpenSYSRNABORPDN19/2/20229/2/2022FinishedFailed6293796231609americascloseonsmile_openNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Open9/2/2022242015df-96aa-45fb-8746-f4e8743ebe6a

ZahinOsman · Answer

Hi Emmanuel,

I was unable to upload even with a zip folder/reducing sample size. So I have copy/pasted a sample size below

Data Set 1;

NameBatch NameUserSubmitted TimeCompleted TimeProgress# Live# TradesWarning CountTotal Error CountLabelFilterRun PathValuation DateRun IDCustom:Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_Revalx013818624480944809FinishedSuccess2270americascloseonsmile_reval_fxspotNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose448065f099913-7827-4bd0-aa5c-732822c33d41Custom:Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_Revalx013818624480944809FinishedSuccess2270americascloseonsmile_revalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose44806b5e5a984-da22-4bac-ba5c-d55aeb2899faCustom:NewYorkClose/EOD_FXO/Flow_Onsmile_PnlcloseIBMO_FX_Amer_PnLClosex013818624480944809FinishedSuccess101650americascloseonsmile_pnlcloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Pnlclose44806316b0729-57f9-4ea7-9853-0e98bc6948feCustom:Flow_Onsmile_OpenIBMO_FX_Amer_Openx013818624480944809FinishedSuccess182450americascloseonsmile_openNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Open44806a9748b2b-4d75-4ceb-a535-ac10e66d327fCustom:Flow_OnsmileIBMO_FX_AmerFlow_Amendsx013818624480944809FinishedSuccess101650americascloseonsmile_amendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile44806b370a984-59d5-4127-bb72-27bdcaea2db7Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalSYSRNABORPDN14480644806FinishedFailed6293796231551americascloseonsmile_revalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose44806fef46e8c-0f4f-43d8-abbe-f6a1cb8e6ee0Flow_Onsmile_RevalOpentoClose_NDFIBMO_FX_Amer_RevalSYSRNABORPDN14480644806FinishedSuccess0130americascloseonsmile_reval_fxspotNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose_NDF4480645458b94-2110-4d63-89eb-be77ecfc60bcCSD_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalSYSRNABORPDN14480644806FinishedSuccess479409030americascloseonsmile_reval_fxspotNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_RevalOpentoClose448068a14a8ec-95d3-4698-938b-a4982ae1932fCSD_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalSYSRNABORPDN14480644806FinishedSuccess479409030americascloseonsmile_revalNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_RevalOpentoClose44806a93d6b55-9f06-4955-a85c-8be49dc90f5dFlow_Onsmile_RevalOpentoClose_NDFIBMO_FX_Amer_RevalSYSRNABORPDN14480644806FinishedSuccess0130americascloseonsmile_revalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose_NDF4480608aecebe-a30a-4c41-bc20-6b9601531e41NewYorkClose/EOD_FXO/Flow_Onsmile_pnlclose_NDFIBMO_FX_Amer_PnLCloseSYSRNABORPDN14480644806FinishedSuccess0110americascloseonsmile_pnlcloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_pnlclose_NDF4480610b89615-6612-4869-b788-e49a239e0685Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalSYSRNABORPDN14480644806FinishedFailed6293796231551americascloseonsmile_reval_fxspotNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose4480648a52def-e2c1-4ce8-9d26-5d5095252eddNewYorkClose/EOD_FXO/CSD_Onsmile_pnlcloseIBMO_FX_Amer_PnLCloseSYSRNABORPDN14480644806FinishedSuccess479409010americascloseonsmile_pnlcloseNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_pnlclose4480679f10c86-fc2a-4259-9f71-db3a282c3e65NewYorkClose/EOD_FXO/Flow_Onsmile_PnlcloseIBMO_FX_Amer_PnLCloseSYSRNABORPDN14480644806FinishedFailed6293796231546americascloseonsmile_pnlcloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Pnlclose4480656e396f7-0185-41fd-a71e-1eb5cfca6323Custom:AmericasClose_Flow_OnsmileIBMO_FX_Amer_CloseX013260904480644806FinishedSuccess121250americascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile448061bab4e50-d5dc-4317-8c25-c170dc3440b6CSD_ClientVal_OnsmileIBMO_FX_Amer_CloseSYSRNABORPDN14480644806FinishedSuccess184510americascloseonsmile_coreclientvalNewYorkClose/RunDefinition/EOD_FXO/CSD_ClientVal_Onsmile4480634e41450-01b9-41ab-a387-8c5bd27b2f69AmericasClose_CSD_OnsmileIBMO_FX_Amer_CloseSYSRNABORPDN14480644806FinishedSuccess479409210americascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile448068e125371-1488-4588-b17b-e55b6ce1d7a3CSD_OnsmileIBMO_FX_AmerFlow_AmendsSYSFXDERIEPDN4480644806FinishedSuccess4610americascloseonsmile_amendsNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile44806451271b5-c8cc-47d3-899a-c5f9316f742aFlow_Onsmile_NDFIBMO_FX_AmerFlow_AmendsSYSFXDERIEPDN4480644806FinishedSuccess0110americascloseonsmile_amendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDF4480684dde59b-d5c9-4766-9dba-700799b9173bLondonClose_LDB_PV_COD_Onsmile_TriadIBMO_FX_Amer_CloseSYSFXDERIEPDN4480644806FinishedSuccess444420londoncloseonsmile_nac_cod_postLondonClose/RunDefinition/EOD_FXO/LDB_PV_COD_Onsmile448068f0785f4-e3be-4331-93d0-b50ade30f91dFlow_OnsmileIBMO_FX_AmerFlow_AmendsSYSFXDERIEPDN4480644806FinishedFailed3133428896americascloseonsmile_amendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile4480665faaae8-5088-4aa1-84f8-70ec813b74c3AmericasClose_Flow_OnsmileIBMO_FX_Amer_CloseSYSFXDERIEPDN4480644806FinishedFailed6238497530541americascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile44806ca7709e3-6834-4801-a741-c1e09cb36e5bAmericasClose_Flow_Onsmile_NDFIBMO_FX_Amer_CloseSYSFXDERIEPDN4480644806FinishedSuccess0110americascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDF448068419eaf8-8356-417e-892a-98b0ef2a7702Flow_Onsmile_Open_NDFIBMO_FX_Amer_OpenSYSRNABORPDN14480644806FinishedSuccess0110americascloseonsmile_openNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Open_NDF4480602b65c13-717f-4948-9c5e-e553c91e61d6CSD_Onsmile_OpenIBMO_FX_Amer_OpenSYSRNABORPDN14480644806FinishedSuccess479409010americascloseonsmile_openNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_Open44806ca91fdcd-6276-488d-b511-04d6eab38449Flow_Onsmile_OpenIBMO_FX_Amer_OpenSYSRNABORPDN14480644806FinishedFailed6293796231609americascloseonsmile_openNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Open

Data set 2;

NoRun_DescriptionBatch_NameRun PathLabelFilter_PrefixFilter_SuffixScheduleHol CalendarRegion Category1CSD_OnsmileIBMO_FX_AmerFlow_AmendsNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmileamericascloseonsmileonsmile_amendsDaily SingaporeFX Amends2Flow_OnsmileIBMO_FX_AmerFlow_AmendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmileamericascloseonsmileonsmile_amendsDaily SingaporeFX Amends3Flow_Onsmile_NDFIBMO_FX_AmerFlow_AmendsNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDFamericascloseonsmileonsmile_amendsDaily SingaporeFX Amends123CSD_ClientVal_OnsmileIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/CSD_ClientVal_Onsmileamericascloseonsmileonsmile_coreclientvalDaily SingaporeFX Main Risk124AmericasClose_CSD_OnsmileIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmileamericascloseonsmileonsmile_coreDaily SingaporeFX Main Risk125AmericasClose_Flow_OnsmileIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmileamericascloseonsmileonsmile_coreDaily SingaporeFX Main Risk126AmericasClose_Flow_Onsmile_NDFIBMO_FX_Amer_CloseNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDFamericascloseonsmileonsmile_coreDaily SingaporeFX Main Risk194LondonClose_LDB_PV_COD_Onsmile_TriadIBMO_FX_Amer_CloseLondonclose/RunDefinition/EOD_FXO/LDB_PV_COD_Onsmilelondoncloseonsmileonsmile_nac_cod_postDaily SingaporeFX Reval195CSD_Onsmile_OpenIBMO_FX_Amer_OpenNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_Openamericascloseonsmileonsmile_openDaily SingaporeFX Reval196Flow_Onsmile_OpenIBMO_FX_Amer_OpenNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Openamericascloseonsmileonsmile_openDaily SingaporeFX Reval197Flow_Onsmile_Open_NDFIBMO_FX_Amer_OpenNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_Open_NDFamericascloseonsmileonsmile_openDaily SingaporeFX Reval202CSD_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_RevalOpentoCloseamericascloseonsmileonsmile_revalDaily SingaporeFX Reval203Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoCloseamericascloseonsmileonsmile_revalDaily SingaporeFX Reval204Flow_Onsmile_RevalOpentoClose_NDFIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose_NDFamericascloseonsmileonsmile_revalDaily SingaporeFX Reval205CSD_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile_RevalOpentoCloseamericascloseonsmileonsmile_reval_fxspotDaily SingaporeFX Reval206Flow_Onsmile_RevalOpentoClose_NDFIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoClose_NDFamericascloseonsmileonsmile_reval_fxspotDaily SingaporeFX Reval207Flow_Onsmile_RevalOpentoCloseIBMO_FX_Amer_RevalNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_RevalOpentoCloseamericascloseonsmileonsmile_reval_fxspotDaily SingaporeFX Reval

I hope the above tables helps. Thank you so much