Icon

9061.K.1_​Belgium_​AnaCredit_​CEP_​stage_​3_​test_​version_​2

9061.K.1_Belgium_AnaCredit_CEP_Phase1_2

Pre-requisites to run this workflow -

1)Input files should be in .xlsx format only
2) Please enter the report date if required. For example output required for a particular yyyy/mm/dd needs to be entered in the report date.
3) Before running the workflow, all the files should be closed.


Please do not change the sheet Name/Tab Name (Case Sensitive) in the existing file. Data should be pasted into input file as it is, in the same row and columns order.

Output files will be created in output folder. Output of this file is to be used in Part II.

Output Name:

*AnaCredit_YYYYMMDD (Un, YYMMDD is the datestamp of the workflow run)

9061.K.1_100151048_Belgium Anacredit CEPEUC ID :100151048Region: EMEA_REGDeveloper: Gaurav ChakrabortyVersion: v1Stage: 2 Note: Input file must be in respective input folder Input File List:AnaCredit - BE.xlsxBelgium_Anacredit_EUC_Credit_report_stage_1_yymmdd.xlsxBelgium_Anacredit_EUC_Credit_report_CAD_OD_2023-05_v15_090723_113607.xlsxBE_AC_FS_FINAL_.xlsxBE_AC_Interest_.xlsxBE_MDS_JUNE_yyyy_nnnnnnn.xlsxCAD_GENESIS_dd_mm_yyyy_BD4.xlsxCAD_INSTRUMENT_.xlsxCopy of yyyymm CEP transactions - Anacredit Only - FINAL_ONLY_QUARTERLY.xlsbG015_BE Sector & SIC Mapping Template_v24.xlsxHistorical_Data_Credit_Instruments_mmyyyy.xlsxNew_Debtor.xlsxOD_GENESIS_dd_mm_yyyy_BD4.xlsxOD_INSTRUMENT_dd_mm_yyyy_BD4.xlsxORR to PD Mapping T10_47_14.xlsxORR_Query Updated_mmmm_ddd_mm_yyyy.xlsxParent.xlsxSA_0010.10_TWEUR.xlsxSchema A working_FFS_yyyy-mm_v18_080423_173223.xlsbS_LR_CAD_WE1_WR_INB_ME_yyyymm_20230706100000000000_156498804_CO.datS_LR_OD_WE1_WR_INB_ME_yyyymm_20230706100000000000_156498779_CO.datOutput File Name: Belgium_Anacredit_EUC_Credit_Report_yyyymmdd_stage_1.xlsx*The workflow might fail/show wrong values if any of the static files/data tabs are missing. check file errorsI/P file listspecify pathvariablesremove tempfileCatch errorsTo select the proper input pathGeneratePrevious monthoutput filefor manual inputs1Converting file name to variabletake latest outputNode 7156FINAL OUTPUTNON RESIDENTSONLYRESIDENTSONLYHeaderFooterXML HeaderRowsNode 7229filter outblanksNode 7231Node 7232Filter RESNode 7234XML HeaderRowsNode 7236Node 7237Node 7238Node 7239Node 7240Node 7241Node 7242Filter NON RESfilter outblanksNode 7245XML HeaderRowsNode 7247Node 7248Node 7249Node 7250Node 7251Node 7252Node 7253Node 7254Node 7255Node 7256Node 7257Node 7258Node 7259Node 7260Node 7261Node 7262Node 7263Node 7264Node 7265Node 7266Node 7267Node 7268Node 7269Node 7270Node 7271Node 7272Node 7275Node 7284 Try (Data Ports) GFT List Files Java Snippet Row Filter APAC WFInitiation v1 Catch Errors(Data Ports) String to Path(Variable) Excel Reader Row Filter Column Rename Table Row to Variable(deprecated) Row Filter Column Rename RowID Table Creator Table Creator Table Creator Table Creator Row Filter Column Filter Row Filter Column Filter Column Filter Row Filter Cross Joiner Row Filter String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Column Filter Concatenate Row Filter Row Filter Cross Joiner Row Filter String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Column Filter Concatenate Concatenate Column Filter Excel Writer String Manipulation 9061.K.1_100151048_Belgium Anacredit CEPEUC ID :100151048Region: EMEA_REGDeveloper: Gaurav ChakrabortyVersion: v1Stage: 2 Note: Input file must be in respective input folderInput File List:AnaCredit - BE.xlsxBelgium_Anacredit_EUC_Credit_report_stage_1_yymmdd.xlsxBelgium_Anacredit_EUC_Credit_report_CAD_OD_2023-05_v15_090723_113607.xlsxBE_AC_FS_FINAL_.xlsxBE_AC_Interest_.xlsxBE_MDS_JUNE_yyyy_nnnnnnn.xlsxCAD_GENESIS_dd_mm_yyyy_BD4.xlsxCAD_INSTRUMENT_.xlsxCopy of yyyymm CEP transactions - Anacredit Only - FINAL_ONLY_QUARTERLY.xlsbG015_BE Sector & SIC Mapping Template_v24.xlsxHistorical_Data_Credit_Instruments_mmyyyy.xlsxNew_Debtor.xlsxOD_GENESIS_dd_mm_yyyy_BD4.xlsxOD_INSTRUMENT_dd_mm_yyyy_BD4.xlsxORR to PD Mapping T10_47_14.xlsxORR_Query Updated_mmmm_ddd_mm_yyyy.xlsxParent.xlsxSA_0010.10_TWEUR.xlsxSchema A working_FFS_yyyy-mm_v18_080423_173223.xlsbS_LR_CAD_WE1_WR_INB_ME_yyyymm_20230706100000000000_156498804_CO.datS_LR_OD_WE1_WR_INB_ME_yyyymm_20230706100000000000_156498779_CO.datOutput File Name: Belgium_Anacredit_EUC_Credit_Report_yyyymmdd_stage_1.xlsx*The workflow might fail/show wrong values if any of the static files/data tabs are missing. check file errorsI/P file listspecify pathvariablesremove tempfileCatch errorsTo select the proper input pathGeneratePrevious monthoutput filefor manual inputs1Converting file name to variabletake latest outputNode 7156FINAL OUTPUTNON RESIDENTSONLYRESIDENTSONLYHeaderFooterXML HeaderRowsNode 7229filter outblanksNode 7231Node 7232Filter RESNode 7234XML HeaderRowsNode 7236Node 7237Node 7238Node 7239Node 7240Node 7241Node 7242Filter NON RESfilter outblanksNode 7245XML HeaderRowsNode 7247Node 7248Node 7249Node 7250Node 7251Node 7252Node 7253Node 7254Node 7255Node 7256Node 7257Node 7258Node 7259Node 7260Node 7261Node 7262Node 7263Node 7264Node 7265Node 7266Node 7267Node 7268Node 7269Node 7270Node 7271Node 7272Node 7275Node 7284Try (Data Ports) GFT List Files Java Snippet Row Filter APAC WFInitiation v1 Catch Errors(Data Ports) String to Path(Variable) Excel Reader Row Filter Column Rename Table Row to Variable(deprecated) Row Filter Column Rename RowID Table Creator Table Creator Table Creator Table Creator Row Filter Column Filter Row Filter Column Filter Column Filter Row Filter Cross Joiner Row Filter String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Column Filter Concatenate Row Filter Row Filter Cross Joiner Row Filter String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Column Filter Concatenate Concatenate Column Filter Excel Writer String Manipulation

Nodes

Extensions

Links