Icon

qa_​VSR_​staging

ACT data (employee swipe information)Input process Split by DQA3 alert statusTable Column Type Value DQActionType STG_ACT_INFO Date_Occurred DATE NULL DQA3STG_ACT_INFO First_Name VARCHAR(30) NULL STG_ACT_INFO Last_Name VARCHAR(30) NULL STG_ACT_INFO Employee_Number VARCHAR(15) NULL DQA3STG_ACT_INFO Card_Number INTEGER DQA3STG_ACT_INFO Earliest_Access_Time TIME NULL DQA3STG_ACT_INFO Earliest_Access_Point VARCHAR(40) NULL STG_ACT_INFO HCL_Facility_E VARCHAR(40) NULL DQA3STG_ACT_INFO Latest_Access_Time TIME NULL DQA3STG_ACT_INFO Latest_Access_Point VARCHAR(40) NULL STG_ACT_INFO HCL_Facility_L VARCHAR(40) NULL STG_ACT_INFO Workgroup VARCHAR(15) NULL Test case #3: Check for date_occurred (format: MM/DD/YYYY) Test case #2: File balance check Test Case #1: Data dictionary check Test case #4: Employee number to be strictly numeric Test case #5: Verify time-based fields (swipe time by employees) Date_Occurred varcharFirst_Name varcharLast_Name varcharEmployee_Number varcharCard_Number varcharEarliest_Access_Time varcharEarliest_Access_Point varcharHCL_Facility_H varcharLatest_Access_Time varcharLatest_Access_Point varcharHCL_Facility_K varcharWorkgroup varcharsrcFilename varcharDatecreated datetime Emp ACT data for 22-MAY-2020Node 2Read the data from Blob csvNode 7Node 8Node 11Node 12Node 13Node 15Node 18Node 19Node 20Node 21Node 22Node 24Node 25Node 26Node 27Node 28Node 29Check for non-numeric dataNode 31Time based columnsNode 33Node 34 Azure Blob StoreFile Picker Azure Blob StoreConnection File Reader Microsoft SQLServer Connector DB Table Selector DB Table Selector DB Query DB Reader DB Reader DB GroupBy GroupBy Column Appender Column Rename Column Rename Check_Date_Occurred_DB DB Reader Check_Date_Occurred_File Joiner RowID RowID String Manipulation Rule-basedRow Splitter String to Date&Time Rule-basedRow Splitter Rule-basedRow Splitter ACT data (employee swipe information)Input process Split by DQA3 alert statusTable Column Type Value DQActionType STG_ACT_INFO Date_Occurred DATE NULL DQA3STG_ACT_INFO First_Name VARCHAR(30) NULL STG_ACT_INFO Last_Name VARCHAR(30) NULL STG_ACT_INFO Employee_Number VARCHAR(15) NULL DQA3STG_ACT_INFO Card_Number INTEGER DQA3STG_ACT_INFO Earliest_Access_Time TIME NULL DQA3STG_ACT_INFO Earliest_Access_Point VARCHAR(40) NULL STG_ACT_INFO HCL_Facility_E VARCHAR(40) NULL DQA3STG_ACT_INFO Latest_Access_Time TIME NULL DQA3STG_ACT_INFO Latest_Access_Point VARCHAR(40) NULL STG_ACT_INFO HCL_Facility_L VARCHAR(40) NULL STG_ACT_INFO Workgroup VARCHAR(15) NULL Test case #3: Check for date_occurred (format: MM/DD/YYYY) Test case #2: File balance check Test Case #1: Data dictionary check Test case #4: Employee number to be strictly numeric Test case #5: Verify time-based fields (swipe time by employees) Date_Occurred varcharFirst_Name varcharLast_Name varcharEmployee_Number varcharCard_Number varcharEarliest_Access_Time varcharEarliest_Access_Point varcharHCL_Facility_H varcharLatest_Access_Time varcharLatest_Access_Point varcharHCL_Facility_K varcharWorkgroup varcharsrcFilename varcharDatecreated datetime Emp ACT data for 22-MAY-2020Node 2Read the data from Blob csvNode 7Node 8Node 11Node 12Node 13Node 15Node 18Node 19Node 20Node 21Node 22Node 24Node 25Node 26Node 27Node 28Node 29Check for non-numeric dataNode 31Time based columnsNode 33Node 34 Azure Blob StoreFile Picker Azure Blob StoreConnection File Reader Microsoft SQLServer Connector DB Table Selector DB Table Selector DB Query DB Reader DB Reader DB GroupBy GroupBy Column Appender Column Rename Column Rename Check_Date_Occurred_DB DB Reader Check_Date_Occurred_File Joiner RowID RowID String Manipulation Rule-basedRow Splitter String to Date&Time Rule-basedRow Splitter Rule-basedRow Splitter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: parth
Created at: 2020-05-19
On NodePit since: 2021-08-31
Last update: 2024-04-27
Created with KNIME version: v4.0.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!