Warning
All
ByName
Union of Data fileds
Union of Data fileds
C:\Users\manin\AppData\Local\Temp\Engine_6572_7715c21c76af46b5b8946594bb886e9e_\Engine_3604_49fb16c8ab3843b8ba7b8295c8eb9943_.yxdb
Single
Profile
Warning
All
ByName
Union of count
Union of count
C:\Users\manin\AppData\Local\Temp\Engine_6572_7715c21c76af46b5b8946594bb886e9e_\Engine_3604_cd7f772d16f44119800b47eb1d6e3e2e_.yxdb
Single
Profile
C:\Users\manin\AppData\Local\Temp\Engine_6572_7715c21c76af46b5b8946594bb886e9e_\Engine_3604_fbb91bb714194237ac90d3e64443e663_.yxdb
Single
Profile
C:\Users\manin\Downloads\FileSubmissions\DataImportExports\Output_with_overwrite.sqlite|||Data
True
False
Output_with_overwrite.sqlite
Query=data
C:\Users\manin\Downloads\FileSubmissions\DataImportExports\Outputfile_PowerBI.csv
CRLF
,
False
True
28591
True
Outputfile_PowerBI.csv
C:\Users\manin\Downloads\FileSubmissions\DataImportExports\Output_with_overwrite.sqlite|||Data
0
False
Overwrite
Output_with_overwrite.sqlite
Query=Data
True
OutputFileAppender (352)
OutputFile Appender
OutputFile Appender
False
manin
https://tableaussi-prod.cibcwm.com
USDataHubReporting
False
False
d6a2b30c-ea52-421d-8b07-314678e91965
DQ_MANUAL_FILE_SUBMISSION
overwrite
hyper
831af9c9-ef17-4de6-bb2a-4a7af082943f
configureConnection
15
84
[{"label":"Allowance (USDHDM) Extract","value":"a0528696-cd7f-432d-9ee8-997d24f61123","sortLabel":"Non-Prod Datasources: Allowance (USDHDM) Extract"},{"label":"AnnualReview (USDHDM)","value":"83d7ddf3-de9d-483f-875d-38a4da236bbb","sortLabel":"Non-Prod Datasources: AnnualReview (USDHDM)"},{"label":"AnnualReview_Monthly (USDHDM)","value":"fec528b8-e7ee-45f6-8962-f0db401381cb","sortLabel":"Non-Prod Datasources: AnnualReview_Monthly (USDHDM)"},{"label":"Client (UAT)","value":"8f925db8-a5b8-4b64-8d40-ce9fc7fe3418","sortLabel":"Non-Prod Datasources: Client (UAT)"},{"label":"Cmmt (USDHDM) Extract","value":"93f69a5b-335f-4549-b3c8-1e8857598760","sortLabel":"Non-Prod Datasources: Cmmt (USDHDM) Extract"},{"label":"Cmmt wObl wBOA (USDHDM) Extract","value":"b1e8d72a-6990-47ba-a6a9-9d3bbf42fb77","sortLabel":"Non-Prod Datasources: Cmmt wObl wBOA (USDHDM) Extract"},{"label":"Cmmt_Acct (UAT)","value":"0f62db11-a3a9-43ea-8b42-91569a280e76","sortLabel":"Non-Prod Datasources: Cmmt_Acct (UAT)"},{"label":"Cmmt_Synd (UAT)","value":"b15b66c9-6931-47c5-9494-96d21319744b","sortLabel":"Non-Prod Datasources: Cmmt_Synd (UAT)"},{"label":"Cmmt_wNAICSBOA_SIT Extract","value":"3b369282-fc26-40ae-be6b-27aac62b8664","sortLabel":"Non-Prod Datasources: Cmmt_wNAICSBOA_SIT Extract"},{"label":"Collateral (UAT)","value":"0c196256-6ccc-41c4-8d8e-47c822d4f7d2","sortLabel":"Non-Prod Datasources: Collateral (UAT)"},{"label":"CommitmentAccount_Monthly (UAT)","value":"42ae49c9-a885-429c-9d1c-1645bb890943","sortLabel":"Non-Prod Datasources: CommitmentAccount_Monthly (UAT)"},{"label":"Covenant (USDHDM)","value":"89878f8e-81ed-41dd-86f3-be44755ed221","sortLabel":"Non-Prod Datasources: Covenant (USDHDM)"},{"label":"LC (UAT)","value":"83cf0330-ff67-466e-b4ef-85271266e73d","sortLabel":"Non-Prod Datasources: LC (UAT)"},{"label":"LC_Monthly (USDHDM) Extract","value":"00ff2497-f126-45be-932a-eefe646fa017","sortLabel":"Non-Prod Datasources: LC_Monthly (USDHDM) Extract"},{"label":"ObligationAccount_Monthly (USDHDM) Extract","value":"745f3b8a-c1b1-4c1d-80a5-c56aa8f24a71","sortLabel":"Non-Prod Datasources: ObligationAccount_Monthly (USDHDM) Extract"},{"label":"Risk_Reference (USDHDM) Extract","value":"829e3343-8ec6-498b-9b02-8234649499b3","sortLabel":"Non-Prod Datasources: Risk_Reference (USDHDM) Extract"},{"label":"Cmmt + Oblig","value":"e6e574c7-0816-42e6-9024-86b565f0d52c","sortLabel":"Production Data: Cmmt + Oblig"},{"label":"Mgmt Limit (Prod Excel)","value":"048912ea-2740-4d73-a156-83c461af5081","sortLabel":"Production Data: Mgmt Limit (Prod Excel)"},{"label":"UnweightedBoardRiskTolerance","value":"a1a10233-f414-4283-9009-c41166854374","sortLabel":"Production Data: UnweightedBoardRiskTolerance"},{"label":"VW_ALLLByBOAGroup","value":"b9d81aa6-d2fd-44cd-bc49-47932a8250cf","sortLabel":"Production Data: VW_ALLLByBOAGroup"},{"label":"VW_AnnualReview_82","value":"b4e4f127-3851-4870-b661-042a84ede2e2","sortLabel":"Production Data: VW_AnnualReview_82"},{"label":"VW_CovenantCompliance_04","value":"cfef5db4-b835-4faa-97ed-02bcc1593e6d","sortLabel":"Production Data: VW_CovenantCompliance_04"},{"label":"VW_ExceptionsReport_46","value":"f464eb34-e112-4075-ab64-5b8d01f9c6fa","sortLabel":"Production Data: VW_ExceptionsReport_46"},{"label":"VW_ExpiryReport_48","value":"09c4b12d-bdf1-449e-be0c-1278fa8960fa","sortLabel":"Production Data: VW_ExpiryReport_48"},{"label":"VW_HigherRiskAssessment_42","value":"dae675e4-f321-4cda-aa8d-c91a8feb202e","sortLabel":"Production Data: VW_HigherRiskAssessment_42"},{"label":"VW_HomeEquityLending_42","value":"27481d2c-7f4b-4497-a2fd-32cfb36b4d3f","sortLabel":"Production Data: VW_HomeEquityLending_42"},{"label":"VW_MasterConsolidated","value":"ae7af860-5601-4b9d-aa46-1b76f7c7a777","sortLabel":"Production Data: VW_MasterConsolidated"},{"label":"VW_ReferenceStatistics","value":"13da26e3-21df-4514-b978-2624410399e2","sortLabel":"Production Data: VW_ReferenceStatistics"},{"label":"VW_Top20LargestClients","value":"fab26648-e547-4cfb-8b62-d44c12e29d6c","sortLabel":"Production Data: VW_Top20LargestClients"},{"label":"VW_ZipCdeMaster","value":"d8256d90-5059-411a-ab06-abbc54ab79ca","sortLabel":"Production Data: VW_ZipCdeMaster"},{"label":"Annual Review (Monthly)","value":"6469eb6e-781e-4526-ad70-09c9558de1f5","sortLabel":"Test DMO: Annual Review (Monthly)"},{"label":"Collateral (Monthly)","value":"dc6ffe63-7ee6-48a9-841a-af5b1b43706b","sortLabel":"Test DMO: Collateral (Monthly)"},{"label":"CommitmentAccount_Daily (Test Z4)","value":"772c385f-28c7-4d3c-9ef8-521a6d9441d3","sortLabel":"Test DMO: CommitmentAccount_Daily (Test Z4)"},{"label":"DevOps","value":"4afe3ad8-1c82-486c-84fc-925ecbcbd309","sortLabel":"Test DMO: DevOps"},{"label":"DQ_ETL","value":"c39eb825-3198-4bc3-9390-08386e2a99d1","sortLabel":"Test DMO: DQ_ETL"},{"label":"DQ_ETL_Duplicates","value":"62155e5d-4086-444d-8fe3-5410a303781d","sortLabel":"Test DMO: DQ_ETL_Duplicates"},{"label":"DQ_GLRecon","value":"bce4fa16-eef6-47f9-81f3-8ac247fd565d","sortLabel":"Test DMO: DQ_GLRecon"},{"label":"DQ_GLRecon_2","value":"17e5baa0-0fd6-44ff-8c37-21d98ede7190","sortLabel":"Test DMO: DQ_GLRecon_2"},{"label":"DQ_GLRecon_AllHistory","value":"4ee95c04-11a1-4155-801f-b0aa593da0c9","sortLabel":"Test DMO: DQ_GLRecon_AllHistory"},{"label":"DQ_GLRecon_Details","value":"036fabb5-914a-40b6-8cd1-33d8cf883a2c","sortLabel":"Test DMO: DQ_GLRecon_Details"},{"label":"DQ_GLRecon_Details_AllHistory","value":"8171b3bb-f111-4c5d-b19b-928a1bec5ef9","sortLabel":"Test DMO: DQ_GLRecon_Details_AllHistory"},{"label":"DQ_LettersOfCredit_Monthly","value":"bf64f22d-8fed-4e19-b050-9b9c9564a2e6","sortLabel":"Test DMO: DQ_LettersOfCredit_Monthly"},{"label":"DQ_OverallList","value":"7aa977aa-c60a-433e-88e4-86227c10676a","sortLabel":"Test DMO: DQ_OverallList"},{"label":"FIS_Universes","value":"a9076b88-64b7-427c-9405-609ecd5fcec6","sortLabel":"Test DMO: FIS_Universes"},{"label":"GL_Recon_Details","value":"e6d1d03c-8092-487f-bdaf-a229d5b18a16","sortLabel":"Test DMO: GL_Recon_Details"},{"label":"GL_UniqueReconKey","value":"770f2c24-e5f7-4f44-ad62-1443d41f646c","sortLabel":"Test DMO: GL_UniqueReconKey"},{"label":"Logged_Bugs","value":"5aa0379f-5f0a-45a2-9d84-4a8f16210bed","sortLabel":"Test DMO: Logged_Bugs"},{"label":"Obligation_All (CRDx)","value":"62e35143-94ac-4023-a9a4-2e9a48a81b34","sortLabel":"Test DMO: Obligation_All (CRDx)"},{"label":"UAT","value":"8f5e5db4-50a1-407d-a0d6-23fa058336de","sortLabel":"Test DMO: UAT"},{"label":"UAT_LOC","value":"a8e92754-9a2e-4984-905d-53e2740c8ac9","sortLabel":"Test DMO: UAT_LOC"},{"label":"UAT_Oblig","value":"10631fd3-4908-4be6-8ee8-e29845ab57f5","sortLabel":"Test DMO: UAT_Oblig"},{"label":"UAT_ServerOutput","value":"cc50093c-68ca-4151-9416-d54efef42688","sortLabel":"Test DMO: UAT_ServerOutput"},{"label":"UAT_ServerOutput_MissingAccts","value":"0e710518-e5c2-4b63-8514-a571038df39d","sortLabel":"Test DMO: UAT_ServerOutput_MissingAccts"},{"label":"UAT_SQL","value":"69ecc0e9-905c-430d-a599-cf11977367b7","sortLabel":"Test DMO: UAT_SQL"},{"label":"09-18LimitsRef(UAT Excel)","value":"dd914847-a12d-4013-bb7b-f879dcd38580","sortLabel":"UAT: 09-18LimitsRef(UAT Excel)"},{"label":"AutoTemplate(UAT Excel)","value":"c92ef1a0-f3f2-4f7f-a94d-52b14ffe4ef1","sortLabel":"UAT: AutoTemplate(UAT Excel)"},{"label":"Leveraged Lending Template (UAT Excel)","value":"6bbbf59b-23ed-477f-b542-91ed75e39882","sortLabel":"UAT: Leveraged Lending Template (UAT Excel)"},{"label":"LLSelectMetrics(UAT Excel)","value":"c5d6b5a1-5f50-451c-b7de-184d9e392bde","sortLabel":"UAT: LLSelectMetrics(UAT Excel)"},{"label":"Mgmt Limit (UAT Excel)","value":"b859b61c-7825-44af-a053-7413cc0ce363","sortLabel":"UAT: Mgmt Limit (UAT Excel)"},{"label":"OilGasUtilities(UAT Excel)","value":"fc9159a9-d511-4bdb-9e9c-3f7c84982d6b","sortLabel":"UAT: OilGasUtilities(UAT Excel)"},{"label":"RefStatistics(UAT Excel)","value":"c909c2b0-b07e-4a70-905d-3d0d7c347382","sortLabel":"UAT: RefStatistics(UAT Excel)"},{"label":"UnweightedBoardRiskTolerance(UAT Excel)","value":"ee939b8f-f52f-4cfe-8947-e4bc9286545f","sortLabel":"UAT: UnweightedBoardRiskTolerance(UAT Excel)"},{"label":"VW_ALLLByBOAGroup (UAT)","value":"eff49c7b-822c-4e0a-9df6-ecb8d0536643","sortLabel":"UAT: VW_ALLLByBOAGroup (UAT)"},{"label":"VW_AnnualReview_82 (UAT)","value":"d98ea630-3f14-4872-a40d-af0b86c068e3","sortLabel":"UAT: VW_AnnualReview_82 (UAT)"},{"label":"VW_AssetQualityWeekly_01_ChangesInAmountWithin (UAT)","value":"2b69ba80-d1a8-413b-9b1c-d7c81ae12319","sortLabel":"UAT: VW_AssetQualityWeekly_01_ChangesInAmountWithin (UAT)"},{"label":"VW_AssetQualityWeekly_01_LoanMovement (UAT)","value":"863f2e40-ce98-4069-8501-888631ea1482","sortLabel":"UAT: VW_AssetQualityWeekly_01_LoanMovement (UAT)"},{"label":"VW_AssetQualityWeekly_01_QuarterlyBalanceChanges_Criticized (UAT)","value":"d14b7495-ac3b-4b89-b3b3-f11cee1842df","sortLabel":"UAT: VW_AssetQualityWeekly_01_QuarterlyBalanceChanges_Criticized (UAT)"},{"label":"VW_AssetQualityWeekly_01_QuarterlyBalanceChanges_Impaired (UAT)","value":"d36b2717-08be-4a15-ae99-82412b32bf2c","sortLabel":"UAT: VW_AssetQualityWeekly_01_QuarterlyBalanceChanges_Impaired (UAT)"},{"label":"VW_AssetQualityWeekly_01_UnfundedBreaksbyAssetQuality (UAT)","value":"2cc068a4-47cd-4f21-a950-b47b4361e6e2","sortLabel":"UAT: VW_AssetQualityWeekly_01_UnfundedBreaksbyAssetQuality (UAT)"},{"label":"VW_Cmmt_Totals (UAT)","value":"23fb2765-f800-447a-814e-d09f31c4d6d3","sortLabel":"UAT: VW_Cmmt_Totals (UAT)"},{"label":"VW_CmmtTotalsByBOAGroup (UAT)","value":"18260d2c-7b74-4da6-a594-2dd6d2f8fb07","sortLabel":"UAT: VW_CmmtTotalsByBOAGroup (UAT)"},{"label":"VW_CmmtTotalsByIndustry (UAT)","value":"5f9fedfe-064c-4dd6-b7b0-f7b393e6e955","sortLabel":"UAT: VW_CmmtTotalsByIndustry (UAT)"},{"label":"VW_CovenantCompliance_04 (UAT)","value":"c07851e6-54b0-41c8-8522-c422c0aba1e5","sortLabel":"UAT: VW_CovenantCompliance_04 (UAT)"},{"label":"VW_ExceptionsReport_46 (UAT)","value":"d5e10fea-e8e5-4cd4-9d67-c936661f545a","sortLabel":"UAT: VW_ExceptionsReport_46 (UAT)"},{"label":"VW_ExpiryReport_48 (UAT)","value":"e698bf2f-7272-4028-9caa-3dda1e8e948b","sortLabel":"UAT: VW_ExpiryReport_48 (UAT)"},{"label":"VW_HigherRiskAssetsAssessment42_Top30HighRiskCICDBorrowers (UAT)","value":"a215b647-d4ab-420a-bb1a-7d68f1943ae1","sortLabel":"UAT: VW_HigherRiskAssetsAssessment42_Top30HighRiskCICDBorrowers (UAT)"},{"label":"VW_HighRiskConsumerReporting","value":"ac88fab3-8b60-438e-b138-67cb5145878e","sortLabel":"UAT: VW_HighRiskConsumerReporting"},{"label":"VW_HomeEquityLending_28 (UAT)","value":"f1c96790-5376-49c7-997a-1e13535beb46","sortLabel":"UAT: VW_HomeEquityLending_28 (UAT)"},{"label":"VW_MasterConsolidated wEBITDA (UAT)","value":"6dbe40c6-90cb-4dbd-bdae-241f61455e4b","sortLabel":"UAT: VW_MasterConsolidated wEBITDA (UAT)"},{"label":"VW_MasterConsolidated_UAT Extract","value":"62bf6217-b905-4895-b767-0b5edbfa7236","sortLabel":"UAT: VW_MasterConsolidated_UAT Extract"},{"label":"VW_MonthlyConsumerDeck&Managment_StandardMetrics_35 (UAT)","value":"6ac9a949-3525-48b5-af02-23193dd89bcd","sortLabel":"UAT: VW_MonthlyConsumerDeck&Managment_StandardMetrics_35 (UAT)"},{"label":"VW_ReferenceStatistics (UAT)","value":"b99609c6-54b0-44ec-b538-8aaa67a6776d","sortLabel":"UAT: VW_ReferenceStatistics (UAT)"},{"label":"VW_Top20LargestClients","value":"cd15edbf-03f4-4951-980f-0f80f285a55e","sortLabel":"UAT: VW_Top20LargestClients"},{"label":"VW_ZipCdeMaster","value":"57a87f63-e6a5-4fe5-8333-51f84982c976","sortLabel":"UAT: VW_ZipCdeMaster"}]
Test DMO
4CA8F7A75E2E27B4E92E59E3A39C63E683A07EA4B9D16AF15301CDA8D18B553169059ACA0C20FD2CE85DC452044041D5BEA25E808ACD80B54EE40CE9172D8CE28A1780D0AD85A134E24E396A8338CDED4E663EB44F76D7BE2630A4D009B6B
470CBF408783411F61E9941D6962F8844D90079615002E96D3F08D8F477D4B268E71782E3B1FD103D8517F5DD603CBB1F97B6A892DCBCA8310D23A5B64612CB30A9D5E6942C39D153ABCAFBE43A3E0F0AE1DC13C70DB80CF112D801F9CE3B564D0CA34F303933261B165F6B4E2992698E9EFC104FC7253B7782110FB9DE3DD973E880D75918921ECE5D49E6A9C99A28C30C9D574BF488C50AFE1C99A9BE4C46339062E10193CDBE23C070504F64E6BD06D7A7E34D977D34DAC49FE956DED9087D68C68CD176FCC45A2CC6C709470604419D6DA736440D9FEF8D898DF09D1B526158D441AFDEDB17ECECEB6DF2A552D5E29011C118DE7A381CE72B584F73DD3DF0624777A9D3B58CA10E5A263790E9B4B4253F48ADC557C93BFC4C52DBB2723C0ECBEE27508A9D8FCB951FBF312C2555F2A63E5E66DC4E5B4153598FD8D183D0C37131C5B238856762F169CCA945D63BCFA36EDE8D1A494BDB3E90306378AEF83500DB69AA6F852848EB7623960956F100F677EF34ECA9572D4745AB771F90122FFB60703F79E26AC57BE552341846DF8F08463593EC46E8047EC42F0A4D46F0DC6465529B1DE1E321D18F4F68716604FA13232E44546B924DF5803910FA48402A8201A4F1139158F7769229A3C43B
False
manin
https://tableaussi-prod.cibcwm.com
USDataHubReporting
False
False
d6a2b30c-ea52-421d-8b07-314678e91965
DQ_MANUAL_FILE_SUBMISSION_COUNT
append
hyper
831af9c9-ef17-4de6-bb2a-4a7af082943f
configureConnection
15
84
[{"label":"Allowance (USDHDM) Extract","value":"a0528696-cd7f-432d-9ee8-997d24f61123","sortLabel":"Non-Prod Datasources: Allowance (USDHDM) Extract"},{"label":"AnnualReview (USDHDM)","value":"83d7ddf3-de9d-483f-875d-38a4da236bbb","sortLabel":"Non-Prod Datasources: AnnualReview (USDHDM)"},{"label":"AnnualReview_Monthly (USDHDM)","value":"fec528b8-e7ee-45f6-8962-f0db401381cb","sortLabel":"Non-Prod Datasources: AnnualReview_Monthly (USDHDM)"},{"label":"Client (UAT)","value":"8f925db8-a5b8-4b64-8d40-ce9fc7fe3418","sortLabel":"Non-Prod Datasources: Client (UAT)"},{"label":"Cmmt (USDHDM) Extract","value":"93f69a5b-335f-4549-b3c8-1e8857598760","sortLabel":"Non-Prod Datasources: Cmmt (USDHDM) Extract"},{"label":"Cmmt wObl wBOA (USDHDM) Extract","value":"b1e8d72a-6990-47ba-a6a9-9d3bbf42fb77","sortLabel":"Non-Prod Datasources: Cmmt wObl wBOA (USDHDM) Extract"},{"label":"Cmmt_Acct (UAT)","value":"0f62db11-a3a9-43ea-8b42-91569a280e76","sortLabel":"Non-Prod Datasources: Cmmt_Acct (UAT)"},{"label":"Cmmt_Synd (UAT)","value":"b15b66c9-6931-47c5-9494-96d21319744b","sortLabel":"Non-Prod Datasources: Cmmt_Synd (UAT)"},{"label":"Cmmt_wNAICSBOA_SIT Extract","value":"3b369282-fc26-40ae-be6b-27aac62b8664","sortLabel":"Non-Prod Datasources: Cmmt_wNAICSBOA_SIT Extract"},{"label":"Collateral (UAT)","value":"0c196256-6ccc-41c4-8d8e-47c822d4f7d2","sortLabel":"Non-Prod Datasources: Collateral (UAT)"},{"label":"CommitmentAccount_Monthly (UAT)","value":"42ae49c9-a885-429c-9d1c-1645bb890943","sortLabel":"Non-Prod Datasources: CommitmentAccount_Monthly (UAT)"},{"label":"Covenant (USDHDM)","value":"89878f8e-81ed-41dd-86f3-be44755ed221","sortLabel":"Non-Prod Datasources: Covenant (USDHDM)"},{"label":"LC (UAT)","value":"83cf0330-ff67-466e-b4ef-85271266e73d","sortLabel":"Non-Prod Datasources: LC (UAT)"},{"label":"LC_Monthly (USDHDM) Extract","value":"00ff2497-f126-45be-932a-eefe646fa017","sortLabel":"Non-Prod Datasources: LC_Monthly (USDHDM) Extract"},{"label":"ObligationAccount_Monthly (USDHDM) Extract","value":"745f3b8a-c1b1-4c1d-80a5-c56aa8f24a71","sortLabel":"Non-Prod Datasources: ObligationAccount_Monthly (USDHDM) Extract"},{"label":"Risk_Reference (USDHDM) Extract","value":"829e3343-8ec6-498b-9b02-8234649499b3","sortLabel":"Non-Prod Datasources: Risk_Reference (USDHDM) Extract"},{"label":"Cmmt + Oblig","value":"e6e574c7-0816-42e6-9024-86b565f0d52c","sortLabel":"Production Data: Cmmt + Oblig"},{"label":"Mgmt Limit (Prod Excel)","value":"048912ea-2740-4d73-a156-83c461af5081","sortLabel":"Production Data: Mgmt Limit (Prod Excel)"},{"label":"UnweightedBoardRiskTolerance","value":"a1a10233-f414-4283-9009-c41166854374","sortLabel":"Production Data: UnweightedBoardRiskTolerance"},{"label":"VW_ALLLByBOAGroup","value":"b9d81aa6-d2fd-44cd-bc49-47932a8250cf","sortLabel":"Production Data: VW_ALLLByBOAGroup"},{"label":"VW_AnnualReview_82","value":"b4e4f127-3851-4870-b661-042a84ede2e2","sortLabel":"Production Data: VW_AnnualReview_82"},{"label":"VW_CovenantCompliance_04","value":"cfef5db4-b835-4faa-97ed-02bcc1593e6d","sortLabel":"Production Data: VW_CovenantCompliance_04"},{"label":"VW_ExceptionsReport_46","value":"f464eb34-e112-4075-ab64-5b8d01f9c6fa","sortLabel":"Production Data: VW_ExceptionsReport_46"},{"label":"VW_ExpiryReport_48","value":"09c4b12d-bdf1-449e-be0c-1278fa8960fa","sortLabel":"Production Data: VW_ExpiryReport_48"},{"label":"VW_HigherRiskAssessment_42","value":"dae675e4-f321-4cda-aa8d-c91a8feb202e","sortLabel":"Production Data: VW_HigherRiskAssessment_42"},{"label":"VW_HomeEquityLending_42","value":"27481d2c-7f4b-4497-a2fd-32cfb36b4d3f","sortLabel":"Production Data: VW_HomeEquityLending_42"},{"label":"VW_MasterConsolidated","value":"ae7af860-5601-4b9d-aa46-1b76f7c7a777","sortLabel":"Production Data: VW_MasterConsolidated"},{"label":"VW_ReferenceStatistics","value":"13da26e3-21df-4514-b978-2624410399e2","sortLabel":"Production Data: VW_ReferenceStatistics"},{"label":"VW_Top20LargestClients","value":"fab26648-e547-4cfb-8b62-d44c12e29d6c","sortLabel":"Production Data: VW_Top20LargestClients"},{"label":"VW_ZipCdeMaster","value":"d8256d90-5059-411a-ab06-abbc54ab79ca","sortLabel":"Production Data: VW_ZipCdeMaster"},{"label":"Annual Review (Monthly)","value":"6469eb6e-781e-4526-ad70-09c9558de1f5","sortLabel":"Test DMO: Annual Review (Monthly)"},{"label":"Collateral (Monthly)","value":"dc6ffe63-7ee6-48a9-841a-af5b1b43706b","sortLabel":"Test DMO: Collateral (Monthly)"},{"label":"CommitmentAccount_Daily (Test Z4)","value":"772c385f-28c7-4d3c-9ef8-521a6d9441d3","sortLabel":"Test DMO: CommitmentAccount_Daily (Test Z4)"},{"label":"DevOps","value":"4afe3ad8-1c82-486c-84fc-925ecbcbd309","sortLabel":"Test DMO: DevOps"},{"label":"DQ_ETL","value":"c39eb825-3198-4bc3-9390-08386e2a99d1","sortLabel":"Test DMO: DQ_ETL"},{"label":"DQ_ETL_Duplicates","value":"62155e5d-4086-444d-8fe3-5410a303781d","sortLabel":"Test DMO: DQ_ETL_Duplicates"},{"label":"DQ_GLRecon","value":"bce4fa16-eef6-47f9-81f3-8ac247fd565d","sortLabel":"Test DMO: DQ_GLRecon"},{"label":"DQ_GLRecon_2","value":"17e5baa0-0fd6-44ff-8c37-21d98ede7190","sortLabel":"Test DMO: DQ_GLRecon_2"},{"label":"DQ_GLRecon_AllHistory","value":"4ee95c04-11a1-4155-801f-b0aa593da0c9","sortLabel":"Test DMO: DQ_GLRecon_AllHistory"},{"label":"DQ_GLRecon_Details","value":"036fabb5-914a-40b6-8cd1-33d8cf883a2c","sortLabel":"Test DMO: DQ_GLRecon_Details"},{"label":"DQ_GLRecon_Details_AllHistory","value":"8171b3bb-f111-4c5d-b19b-928a1bec5ef9","sortLabel":"Test DMO: DQ_GLRecon_Details_AllHistory"},{"label":"DQ_LettersOfCredit_Monthly","value":"bf64f22d-8fed-4e19-b050-9b9c9564a2e6","sortLabel":"Test DMO: DQ_LettersOfCredit_Monthly"},{"label":"DQ_OverallList","value":"7aa977aa-c60a-433e-88e4-86227c10676a","sortLabel":"Test DMO: DQ_OverallList"},{"label":"FIS_Universes","value":"a9076b88-64b7-427c-9405-609ecd5fcec6","sortLabel":"Test DMO: FIS_Universes"},{"label":"GL_Recon_Details","value":"e6d1d03c-8092-487f-bdaf-a229d5b18a16","sortLabel":"Test DMO: GL_Recon_Details"},{"label":"GL_UniqueReconKey","value":"770f2c24-e5f7-4f44-ad62-1443d41f646c","sortLabel":"Test DMO: GL_UniqueReconKey"},{"label":"Logged_Bugs","value":"5aa0379f-5f0a-45a2-9d84-4a8f16210bed","sortLabel":"Test DMO: Logged_Bugs"},{"label":"Obligation_All (CRDx)","value":"62e35143-94ac-4023-a9a4-2e9a48a81b34","sortLabel":"Test DMO: Obligation_All (CRDx)"},{"label":"UAT","value":"8f5e5db4-50a1-407d-a0d6-23fa058336de","sortLabel":"Test DMO: UAT"},{"label":"UAT_LOC","value":"a8e92754-9a2e-4984-905d-53e2740c8ac9","sortLabel":"Test DMO: UAT_LOC"},{"label":"UAT_Oblig","value":"10631fd3-4908-4be6-8ee8-e29845ab57f5","sortLabel":"Test DMO: UAT_Oblig"},{"label":"UAT_ServerOutput","value":"cc50093c-68ca-4151-9416-d54efef42688","sortLabel":"Test DMO: UAT_ServerOutput"},{"label":"UAT_ServerOutput_MissingAccts","value":"0e710518-e5c2-4b63-8514-a571038df39d","sortLabel":"Test DMO: UAT_ServerOutput_MissingAccts"},{"label":"UAT_SQL","value":"69ecc0e9-905c-430d-a599-cf11977367b7","sortLabel":"Test DMO: UAT_SQL"},{"label":"09-18LimitsRef(UAT Excel)","value":"dd914847-a12d-4013-bb7b-f879dcd38580","sortLabel":"UAT: 09-18LimitsRef(UAT Excel)"},{"label":"AutoTemplate(UAT Excel)","value":"c92ef1a0-f3f2-4f7f-a94d-52b14ffe4ef1","sortLabel":"UAT: AutoTemplate(UAT Excel)"},{"label":"Leveraged Lending Template (UAT Excel)","value":"6bbbf59b-23ed-477f-b542-91ed75e39882","sortLabel":"UAT: Leveraged Lending Template (UAT Excel)"},{"label":"LLSelectMetrics(UAT Excel)","value":"c5d6b5a1-5f50-451c-b7de-184d9e392bde","sortLabel":"UAT: LLSelectMetrics(UAT Excel)"},{"label":"Mgmt Limit (UAT Excel)","value":"b859b61c-7825-44af-a053-7413cc0ce363","sortLabel":"UAT: Mgmt Limit (UAT Excel)"},{"label":"OilGasUtilities(UAT Excel)","value":"fc9159a9-d511-4bdb-9e9c-3f7c84982d6b","sortLabel":"UAT: OilGasUtilities(UAT Excel)"},{"label":"RefStatistics(UAT Excel)","value":"c909c2b0-b07e-4a70-905d-3d0d7c347382","sortLabel":"UAT: RefStatistics(UAT Excel)"},{"label":"UnweightedBoardRiskTolerance(UAT Excel)","value":"ee939b8f-f52f-4cfe-8947-e4bc9286545f","sortLabel":"UAT: UnweightedBoardRiskTolerance(UAT Excel)"},{"label":"VW_ALLLByBOAGroup (UAT)","value":"eff49c7b-822c-4e0a-9df6-ecb8d0536643","sortLabel":"UAT: VW_ALLLByBOAGroup (UAT)"},{"label":"VW_AnnualReview_82 (UAT)","value":"d98ea630-3f14-4872-a40d-af0b86c068e3","sortLabel":"UAT: VW_AnnualReview_82 (UAT)"},{"label":"VW_AssetQualityWeekly_01_ChangesInAmountWithin (UAT)","value":"2b69ba80-d1a8-413b-9b1c-d7c81ae12319","sortLabel":"UAT: VW_AssetQualityWeekly_01_ChangesInAmountWithin (UAT)"},{"label":"VW_AssetQualityWeekly_01_LoanMovement (UAT)","value":"863f2e40-ce98-4069-8501-888631ea1482","sortLabel":"UAT: VW_AssetQualityWeekly_01_LoanMovement (UAT)"},{"label":"VW_AssetQualityWeekly_01_QuarterlyBalanceChanges_Criticized (UAT)","value":"d14b7495-ac3b-4b89-b3b3-f11cee1842df","sortLabel":"UAT: VW_AssetQualityWeekly_01_QuarterlyBalanceChanges_Criticized (UAT)"},{"label":"VW_AssetQualityWeekly_01_QuarterlyBalanceChanges_Impaired (UAT)","value":"d36b2717-08be-4a15-ae99-82412b32bf2c","sortLabel":"UAT: VW_AssetQualityWeekly_01_QuarterlyBalanceChanges_Impaired (UAT)"},{"label":"VW_AssetQualityWeekly_01_UnfundedBreaksbyAssetQuality (UAT)","value":"2cc068a4-47cd-4f21-a950-b47b4361e6e2","sortLabel":"UAT: VW_AssetQualityWeekly_01_UnfundedBreaksbyAssetQuality (UAT)"},{"label":"VW_Cmmt_Totals (UAT)","value":"23fb2765-f800-447a-814e-d09f31c4d6d3","sortLabel":"UAT: VW_Cmmt_Totals (UAT)"},{"label":"VW_CmmtTotalsByBOAGroup (UAT)","value":"18260d2c-7b74-4da6-a594-2dd6d2f8fb07","sortLabel":"UAT: VW_CmmtTotalsByBOAGroup (UAT)"},{"label":"VW_CmmtTotalsByIndustry (UAT)","value":"5f9fedfe-064c-4dd6-b7b0-f7b393e6e955","sortLabel":"UAT: VW_CmmtTotalsByIndustry (UAT)"},{"label":"VW_CovenantCompliance_04 (UAT)","value":"c07851e6-54b0-41c8-8522-c422c0aba1e5","sortLabel":"UAT: VW_CovenantCompliance_04 (UAT)"},{"label":"VW_ExceptionsReport_46 (UAT)","value":"d5e10fea-e8e5-4cd4-9d67-c936661f545a","sortLabel":"UAT: VW_ExceptionsReport_46 (UAT)"},{"label":"VW_ExpiryReport_48 (UAT)","value":"e698bf2f-7272-4028-9caa-3dda1e8e948b","sortLabel":"UAT: VW_ExpiryReport_48 (UAT)"},{"label":"VW_HigherRiskAssetsAssessment42_Top30HighRiskCICDBorrowers (UAT)","value":"a215b647-d4ab-420a-bb1a-7d68f1943ae1","sortLabel":"UAT: VW_HigherRiskAssetsAssessment42_Top30HighRiskCICDBorrowers (UAT)"},{"label":"VW_HighRiskConsumerReporting","value":"ac88fab3-8b60-438e-b138-67cb5145878e","sortLabel":"UAT: VW_HighRiskConsumerReporting"},{"label":"VW_HomeEquityLending_28 (UAT)","value":"f1c96790-5376-49c7-997a-1e13535beb46","sortLabel":"UAT: VW_HomeEquityLending_28 (UAT)"},{"label":"VW_MasterConsolidated wEBITDA (UAT)","value":"6dbe40c6-90cb-4dbd-bdae-241f61455e4b","sortLabel":"UAT: VW_MasterConsolidated wEBITDA (UAT)"},{"label":"VW_MasterConsolidated_UAT Extract","value":"62bf6217-b905-4895-b767-0b5edbfa7236","sortLabel":"UAT: VW_MasterConsolidated_UAT Extract"},{"label":"VW_MonthlyConsumerDeck&Managment_StandardMetrics_35 (UAT)","value":"6ac9a949-3525-48b5-af02-23193dd89bcd","sortLabel":"UAT: VW_MonthlyConsumerDeck&Managment_StandardMetrics_35 (UAT)"},{"label":"VW_ReferenceStatistics (UAT)","value":"b99609c6-54b0-44ec-b538-8aaa67a6776d","sortLabel":"UAT: VW_ReferenceStatistics (UAT)"},{"label":"VW_Top20LargestClients","value":"cd15edbf-03f4-4951-980f-0f80f285a55e","sortLabel":"UAT: VW_Top20LargestClients"},{"label":"VW_ZipCdeMaster","value":"57a87f63-e6a5-4fe5-8333-51f84982c976","sortLabel":"UAT: VW_ZipCdeMaster"}]
Test DMO
4CA8F7A75E2E27B4E92E59E3A39C63E683A07EA4B9D16AF15301CDA8D18B553169059ACA0C20FD2CE85DC452044041D5BEA25E808ACD80B54EE40CE9172D8CE28A1780D0AD85A134E24E396A8338CDED4E663EB44F76D7BE2630A4D009B6B
439F6EE1EC6A3825E893D134D0577C43CFA21D086A57FA26786BB11A219ADCA12D70BADB5244EA44DF8746C69B072C8A1566521919A78D1530D1D67BAA63CD313D52F481B89E830A83FC48D0CDB7B2B82A352213C62E25AAF5AE1149D59C66A229B9A6E0E0FD3E3C8C9D2E1289475D8BEF55C673080696C733EE6E495F49A7331A5973CC692470FBFE20205F91901BC9490AA14E78A6B51C849D04C9D3E8931E6F81BE39247F4CE95B938849EDD7213CEB050FB2F5F823DC5CD9267B4F8EA69FB865C0C12031440F88E88B0C913E91083B743DCFC40C84CAC51EA62C75F433D4D1F76F00C7D998E7F3FF8401FB4BED1029C1F22B6DC469F7E51FA29E8287A2276BB3C9753131407CB2ACA67D693F8D93C96EBF20CC728BAC5E65AB00D44CF0E88C8B1B119F924716986ECD5A151107118E0C6962E086EF6E62D6613BCD5D0BDEDA49B9580FA2243E3E92D86C64037DB98C40C46940F1490DC68D09A598F779422567E5A821FD827ABD74482494F630FC72EFA4276038BBF6548D226BBE5E3E607FACBA86FF14A1A260D6EDF860A8D075FE6A5368D211503331C13CEAB9F3D1FD41F278A3820B5202809CAE95E02B131CECECF96B4A2C34819C1B091420BB032B460B74FCBE6C63C942A496301E948
C:\Users\manin\Downloads\FileSubmissions\DataImportExports\test_csv.csv
CRLF
,
False
True
28591
False
test_csv.csv
Borrower Financials
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null() else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null()
elseif Uppercase(ToString([_CurrentField_])) == 'TRUE' then 1
elseif Uppercase(ToString([_CurrentField_])) == 'FALSE' then 0
else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
Creating unique key identifier
Key_Identifier_Source = IIF(IsNull([SourceCustomerID]), [SourceCustomerID], [Sou...
Creating unique key identifier
Key_Identifier_Target = IIF(IsNull([SourceCustomerAcctNbr]), [SourceCustomerAcct...
All
if [_CurrentField_] == 'CISNumber' then 'CISAcctNbr' elseif [_CurrentField_] == 'StatementDate' then 'StatementDateSK'
elseif [_CurrentField_] == 'SmallBusinessIndicator' then 'SmallBusinessInd'
elseif [_CurrentField_] == 'DateofData' then 'AsOfDateSK'
else [_CurrentField_] endif
Assign Target Column Name
if [_CurrentField_] == 'CISNumber' then 'CISAcctNbr' elseif [...
NumericHandelingWorkflow (216)
NumericHandler
NumericHandler
C:\Users\manin\Downloads\FileSubmissions\Template\Source\BorrowerFinancials\BorrowerFinancials.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
ReadList
FullPath
Path
Source Template
Source Template
C:\Users\manin\Downloads\FileSubmissions\Source\BorrowerFinancials\Submitted\
BorrowerFinancials.csv
Source BorrowerFinancials
dir C:\Users\manin\Downloads\FileSubmissions\Source\BorrowerFinancials\Submitted\BorrowerFinancials.csv
Create output filename
OutputFile = [Directory] + 'Validated\'+Substring([FileName],0,length([FileName]...
FileMover (307)
FileMover
FileMover
File Checker
File Checker
TransposeWorkflow (213)
Transpose
Transpose
Error
Simple
=
SourceCount
True
fixed
2022-03-08 23:39:52
0
1
2022-03-08 23:39:52
2022-03-08 23:39:52
[SourceCount] = 1
C:\Users\manin\AppData\Local\Temp\Engine_6572_7715c21c76af46b5b8946594bb886e9e_\Engine_3604_24d9d56f4db8469cab683d1366367eb5_.yxdb
Single
Profile
query = "select * from BuyMetals.dbo.[USDH BorrowerFinancials] where AsOfDateSK=...
connection_name
query
US Allowance
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null() else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null() else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
Creating unique key identifier
Key_Identifier_Source = IIF(IsNull([InstrumentAccountNumber]), [InstrumentAccoun...
Creating unique key identifier
Key_Identifier_Target = IIF(IsNull([InstrumentAcctNbr]), [InstrumentAcctNbr], [I...
All
if [_CurrentField_] == 'BranchOfAccount' then 'BranchOfAcct'
elseif [_CurrentField_] == 'InstrumentAccountNumber' then 'InstrumentAcctNbr'
elseif [_CurrentField_] == 'InstrumentCategory' then 'InstrumentCat'
elseif [_CurrentField_] == 'USGAAPAllowanceCategory' then 'USGAAPAllowanceCat'
elseif [_CurrentField_] == 'IFRSAllowanceCategory' then 'IFRSAllowanceCat'
elseif [_CurrentField_] == 'USGAAPProvisionBalance' then 'USGAAPProvisionAmtUSD'
elseif [_CurrentField_] == 'IFRSProvisionBalance' then 'IFRSProvisionAmtUSD'
elseif [_CurrentField_] == 'MTDChargeOffs' then 'ChargeOffAmtMTDUSD'
elseif [_CurrentField_] == 'MTDRecoveries' then 'RecoveriesAmtMTDUSD'
elseif [_CurrentField_] == 'DateofData' then 'AsOfDateSK'
else [_CurrentField_] endif
Assign Target Column Name
if [_CurrentField_] == 'BranchOfAccount' then 'BranchOfAcct' ...
NumericHandelingWorkflow (217)
NumericHandler
NumericHandler
C:\Users\manin\Downloads\FileSubmissions\Template\Source\USAllowance\USAllowance.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
ReadList
FullPath
Path
Source Template
Source Template
C:\Users\manin\Downloads\FileSubmissions\Source\USAllowance\Submitted\
USAllowance.csv
Source USAllowance
dir C:\Users\manin\Downloads\FileSubmissions\Source\USAllowance\Submitted\USAllowance.csv
Create output filename
OutputFile = [Directory] + 'Validated\'+Substring([FileName],0,length([FileName]...
FileMover (309)
FileMover
FileMover
File Checker
File Checker
TransposeWorkflow (215)
Transpose
Transpose
query = "select * from BuyMetals.dbo.[USDH USAllowance] where AsOfDateSK='"+[Max...
connection_name
query
FHLB Collateral
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null() else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
Creating unique key identifier
Key_Identifier_Source = IIF(IsNull([CollateralDescription]), [CollateralDescript...
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null() else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
Creating unique key identifier
Key_Identifier_Target = IIF(IsNull([CollDesc]), [CollDesc], [CollDesc]+'; ')+ II...
All
if [_CurrentField_] == 'CollateralSupplied' then 'CollSuppliedAmtUSD'
elseif [_CurrentField_] == 'CollateralMaximumAllowed' then 'CollMaxAllowedAmtUSD'
elseif [_CurrentField_] == 'CollateralMaximumAllowed' then 'CollMaxAllowedAmtUSD'
elseif [_CurrentField_] == 'CollateralMargin' then 'CollMargin'
elseif [_CurrentField_] == 'CollateralValue' then 'CollValueAmtUSD'
elseif [_CurrentField_] == 'DateofData' then 'AsOfDateSK'
else [_CurrentField_] endif
Assign Target Column Name
if [_CurrentField_] == 'CollateralSupplied' then 'CollSupplie...
NumericHandelingWorkflow (212)
NumericHandler
NumericHandler
C:\Users\manin\Downloads\FileSubmissions\Template\Source\FHLBCollateral\FHLBCollateral.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
ReadList
FullPath
Path
Source Template
Source Template
C:\Users\manin\Downloads\FileSubmissions\Source\FHLBCollateral\Submitted\
FHLBCollateral.csv
Source FHLBCollateral
dir C:\Users\manin\Downloads\FileSubmissions\Source\FHLBCollateral\Submitted\FHLBCollateral.csv
Create output filename
OutputFile = [Directory] + 'Validated\'+Substring([FileName],0,length([FileName]...
FileMover (303)
Source FileMover
FileMover
File Checker
File Checker
TransposeWorkflow (211)
Transpose
Transpose
query = "select * from BuyMetals.dbo.[USDH FHLBCollateral] where AsOfDateSK='"+[...
connection_name
query
FRB Collateral
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null() else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null() else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
Creating unique key identifier
Key_Identifier_Source = IIF(IsNull([ABANo]), [ABANo], [ABANo]+'; ')+ IIF(IsNull...
Creating unique key identifier
Key_Identifier_Target = IIF(IsNull([ABANbr]), [ABANbr], [ABANbr]+'; ')+ IIF(IsN...
All
if [_CurrentField_] == 'AdviceNo' then 'AdviceNbr' elseif [_CurrentField_] == 'IdentifierDescription' then 'IDDesc'
elseif [_CurrentField_] == 'Category' then 'Cat'
elseif [_CurrentField_] == 'MaturityDate' then 'MaturityDateSK'
elseif [_CurrentField_] == 'Loc' then 'LOC'
elseif [_CurrentField_] == 'OriginalParAmt' then 'OriginalParAmtUSD'
elseif [_CurrentField_] == 'CurrentOutstandingBalance' then 'CurrentOutstandingAmtUSD'
elseif [_CurrentField_] == 'CollateralValue' then 'CollValueAmtUSD'
elseif [_CurrentField_] == 'DateofData' then 'AsOfDateSK'
else [_CurrentField_] endif
Assign Target Column Name
if [_CurrentField_] == 'AdviceNo' then 'AdviceNbr' elseif [_C...
NumericHandelingWorkflow (12)
NumericHandler
NumericHandler
C:\Users\manin\Downloads\FileSubmissions\Source\FRBCollateral\Submitted\
FRBCollateral.csv
Source FRBCollateral
dir C:\Users\manin\Downloads\FileSubmissions\Source\FRBCollateral\Submitted\FRBCollateral.csv
C:\Users\manin\Downloads\FileSubmissions\Template\Source\FRBCollateral\FRBCollateral.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
ReadList
FullPath
Path
Source Template
Source Template
Create output filename
OutputFile = [Directory] + 'Validated\'+Substring([FileName],0,length([FileName]...
FileMover (306)
FileMover
FileMover
File Checker
File Checker
TransposeWorkflow (219)
Transpose
Transpose
query = "select * from BuyMetals.dbo.[USDH FRBCollateral] where AsOfDateSK='"+[M...
connection_name
query
ManualFees
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null() else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
All
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null() else [_CurrentField_] endif
NULL Cleanup
if Uppercase(ToString([_CurrentField_])) == 'NULL' then null(...
Creating unique key identifier
Key_Identifier_Source = IIF(IsNull([CommitmentAccountNumber]), [CommitmentAccoun...
Creating unique key identifier
Key_Identifier_Target = IIF(IsNull([CmmtAcctNbr]), [CmmtAcctNbr], [CmmtAcctNbr]+...
All
if [_CurrentField_] == 'CommitmentAccountNumber' then 'CmmtAcctNbr'
elseif [_CurrentField_] == 'ObligationAccountNumber' then 'ObligAcctNbr'
elseif [_CurrentField_] == 'CustomerShortName' then 'ClientShortName'
elseif [_CurrentField_] == 'FeeDescription' then 'FeeDesc'
elseif [_CurrentField_] == 'FeeCategoryCode' then 'FeeCatCde'
elseif [_CurrentField_] == 'FeePlanCode' then 'FeePlanCde'
elseif [_CurrentField_] == 'FeePlanSchedule' then 'FeePlanNbr'
elseif [_CurrentField_] == 'FeeErngsCode' then 'FeeEarningsCde'
elseif [_CurrentField_] == 'FeeEffectiveDate' then 'FeeEffectiveDateSK'
elseif [_CurrentField_] == 'FeeExpirationDate' then 'FeeExpirationDateSK'
elseif [_CurrentField_] == 'FeeAmountEarnedMTD' then 'FeeEarnedAmtMTDUSD'
elseif [_CurrentField_] == 'FeeDeferredCurrentAmount' then 'FeeDeferredCurrentAmtUSD'
elseif [_CurrentField_] == 'FeeOriginalAmount' then 'FeeOriginalAmtUSD'
elseif [_CurrentField_] == 'FeeWaivedAmountMTD' then 'FeeWaivedAmtMTDUSD'
elseif [_CurrentField_] == 'GLAccountNumberDeferredSource' then 'SourceGLAcctDeferred'
elseif [_CurrentField_] == 'GLAccountNumberDeferredCCISUSGAAP' then 'CCISGLAcctDeferredUSGAAP'
elseif [_CurrentField_] == 'GLAccountNumberDeferredCCISIFRS' then 'CCISGLAcctDeferredIFRS'
elseif [_CurrentField_] == 'GLAccountNumberIncomeSource' then 'SourceGLAcctIncome'
elseif [_CurrentField_] == 'GLAccountNumberIncomeCCISUSGAAP' then 'CCISGLAcctIncomeUSGAAP'
elseif [_CurrentField_] == 'GLAccountNumberIncomeCCISIFRS' then 'CCISGLAcctIncomeIFRS'
elseif [_CurrentField_] == 'DateofData' then 'AsOfDateSK'
else [_CurrentField_] endif
Assign Target Column Name
if [_CurrentField_] == 'CommitmentAccountNumber' then 'CmmtAc...
NumericHandelingWorkflow (218)
NumericHandler
NumericHandler
C:\Users\manin\Downloads\FileSubmissions\Template\Source\ManualFees\ManualFees.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
ReadList
FullPath
Path
Source Template
Source Template
C:\Users\manin\Downloads\FileSubmissions\Source\ManualFees\Submitted\
*.*
Source ManualFees
dir C:\Users\manin\Downloads\FileSubmissions\Source\ManualFees\Submitted\*.*
Create output filename
OutputFile = [Directory] + 'Validated\'+Substring([FileName],0,length([FileName]...
FileMover (311)
FileMover
FileMover
File Checker
File Checker
TransposeWorkflow (214)
Transpose
Transpose
query = "select * from BuyMetals.dbo.[USDH ManualFees_Summary] where AsOfDateSK=...
connection_name
query
Horizontal
USDH_CSV_DB_check_Workflow
Tab
Questions
Tab (262)
Macro
AllSame