Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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_Description | Batch_Name | Run Path | Label | Filter_Prefix | Filter_Suffix | Schedule | Hol Calendar | Region | Category | Run++ | Run Today? | Initial Run Status | Run count | Run Deleted? |
| AmericasClose_CSD_1F | IBMO_FX_Amer_Close | NewYorkClose/RunDefinition/EOD_FXO/CSD_1F_HVAR | americasclose | 1f | 1f_pure_core | Daily | Singapore | FX Amer Core | AmericasClose_CSD_1FIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_1F_HVAR | TRUE | Missing | 0 | NO | |
| AmericasClose_Flow_1f_Hvar | IBMO_FX_Amer_Close | NewYorkClose/RunDefinition/EOD_FXO/Flow_1F_HVAR | americasclose | 1f_pure | 1f_pure_core | Daily | Singapore | FX Amer Core | AmericasClose_Flow_1f_HvarIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_1F_HVAR | TRUE | Missing | 0 | NO | |
| AmericasClose_Flow_1f_Hvar_NDF | IBMO_FX_Amer_Close | NewYorkClose/RunDefinition/EOD_FXO/Flow_1F_HVAR_NDF | americasclose | 1f | 1f_pure_core | Daily | Singapore | FX Amer Core | AmericasClose_Flow_1f_Hvar_NDFIBMO_FX_Amer_Closeamericasclose1f_pure_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_1F_HVAR_NDF | TRUE | Missing | 0 | NO | |
| CVAR_Base_NonLD | IBMO_FX_Amer_Close | Official_EOD/RunDefinition/CVAR/CVAR_Base_NonLD | barx_americasclose | onsmile | onsmile_MurexRec | Daily | Singapore | FX CVAR | CVAR_Base_NonLDIBMO_FX_Amer_Closebarx_americascloseonsmile_MurexRecOfficial_EOD/RunDefinition/CVAR/CVAR_Base_NonLD | TRUE | Missing | 0 | NO | |
| CVAR_Base_LD | IBMO_FX_Amer_Close | Official_EOD/RunDefinition/CVAR/CVAR_Base_LD | barx_americasclose | onsmile | onsmile_MurexRec | Daily | Singapore | FX CVAR | CVAR_Base_LDIBMO_FX_Amer_Closebarx_americascloseonsmile_MurexRecOfficial_EOD/RunDefinition/CVAR/CVAR_Base_LD | TRUE | Missing | 0 | NO | |
| CSD_ClientVal_Onsmile | IBMO_FX_Amer_Close | NewYorkClose/RunDefinition/EOD_FXO/CSD_ClientVal_Onsmile | americasclose | onsmile | onsmile_coreclientval | Daily | Singapore | FX Main Risk | CSD_ClientVal_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreclientvalNewYorkClose/RunDefinition/EOD_FXO/CSD_ClientVal_Onsmile | TRUE | Missing | 0 | NO | |
| AmericasClose_CSD_Onsmile | IBMO_FX_Amer_Close | NewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile | americasclose | onsmile | onsmile_core | Daily | Singapore | FX Main Risk | AmericasClose_CSD_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/CSD_Onsmile | TRUE | Missing | 0 | NO | |
| AmericasClose_Flow_Onsmile | IBMO_FX_Amer_Close | NewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile | americasclose | onsmile | onsmile_core | Daily | Singapore | FX Main Risk | AmericasClose_Flow_OnsmileIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile | TRUE | Missing | 0 | NO | |
| AmericasClose_Flow_Onsmile_NDF | IBMO_FX_Amer_Close | NewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDF | americasclose | onsmile | onsmile_core | Daily | Singapore | FX Main Risk | AmericasClose_Flow_Onsmile_NDFIBMO_FX_Amer_Closeamericascloseonsmile_coreNewYorkClose/RunDefinition/EOD_FXO/Flow_Onsmile_NDF | TRUE | Missing | 0 | NO | |
| LondonClose_LDB_PV_COD_Onsmile_Triad | IBMO_FX_Amer_Close | Londonclose/RunDefinition/EOD_FXO/LDB_PV_COD_Onsmile | londonclose | onsmile | onsmile_nac_cod_post | Daily | Singapore | FX Reval | LondonClose_LDB_PV_COD_Onsmile_TriadIBMO_FX_Amer_Closelondoncloseonsmile_nac_cod_postLondonclose/RunDefinition/EOD_FXO/LDB_PV_COD_Onsmile | TRUE | Missing | 0 | NO | |
| CSD_Spotladder20pc | IBMO_FX_Amer_Close | NewYorkClose/RunDefinition/EOD_FXO/CSD_Spotladder20pc | americasclose | onsmile | onsmile_spotladder20pc | Daily | Singapore | FX Scenarios | CSD_Spotladder20pcIBMO_FX_Amer_Closeamericascloseonsmile_spotladder20pcNewYorkClose/RunDefinition/EOD_FXO/CSD_Spotladder20pc | TRUE | Missing | 0 | NO | |
| Flow_Spotladder20pc | IBMO_FX_Amer_Close | NewYorkClose/RunDefinition/EOD_FXO/Flow_Spotladder20pc | americasclose | onsmile | onsmile_spotladder20pc | Daily | Singapore | FX Scenarios | Flow_Spotladder20pcIBMO_FX_Amer_Closeamericascloseonsmile_spotladder20pcNewYorkClose/RunDefinition/EOD_FXO/Flow_Spotladder20pc | TRUE | Missing | 0 | NO |
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
Hi @ZahinOsman ,
Is it possible to put them in a .zip file?
Otherwise, you can use sample tool on each file to export just some rows to reduce the size of files and export theses samples and share them with us. ( Find attached an example )
