Icon

RBS_​Sample_​KnimeHub_​Excel

Step 2 : PASS AS IS Records Step 3 : Filter Duplicate Records Rehire Logic PASS AS IS PLANS Work flow: 1A Record Type =11N FPRS Shell Account ExistsFPRS Status Code =TRecord 61 not sentMissing Record 61 Work flow: 1B Record Type =11N FPRS Shell Account existsFPRS Status Code =TRecord 61 is sentMissing Record 61 Work flow: 1C Record Type =11N FPRS Shell Account does not existsRecord 61 is not sent Work flow: 1D Record Type =11N FPRS Shell Account does not existsRecord 61 is sent Work flow: 2C Record Type =11H FPRS Shell Account existsRecord 61 is sentNo change, o2,11 and 61 Pass AS IS Work flow: 2D Record Type =11H FPRS Shell Account existsRecord 61 is not sentNio change to Record 02,11 nd creae a zerofill Record 61 Work flow: 2A Record Type =11H FPRS Shell Account does not existsSSN Not present in Hist DBRecord 61 ExistsNio change to Record 02,11 nd creae a zerofill Record 61 Work flow: 2E Record Type =11H FPRS Shell Account does not existsSSN Presnt in Historic DBRecord 61 is sentNio change to Record 02,11 nd creae a zerofill Record 61 Work flow: 2F Record Type =11H FPRS Shell Account does not existsSSN Presnt in Historic DBRecord 61 not sentNio change to Record 02,11 nd creae a zerofill Record 61 Work flow: 2B Record Type =11H FPRS Shell Account does not existsSSN Not present in Hist DBRecord 61 is not sent, create a zerofill record 61Nio change to Record 02,11 nd creae a zerofill Record 61 Test Case 2E Day 1 Report Test Case 2E Day 2 Report Test Case 2F Day 1 Report Test Case 2F Day 2 Report Work flow: 3A,3B Record Type =11T FPRS Shell Account does not existsRecord 61 sent or not sent : Remove Records Filter Invalid Record TypesSplit the Recordsto columnsFilter Invalid and Misisng Plan numbersSplitting Plans Pass AS ISand Plans that go thru Rehire LogicCombine the PASS AS IS RecordsDuplicate 11 removedremove the column split and get the original dataas in filePlans Eligible forRehire Logic: Split the PASS AS IS Record Typesand Records that gothru Rehire Logic 02D,11,61remove the column splitand get the original dataas in fileFetching a setof records per SSN and PlanJoining the Rehire Logic Records with FPRS Recordsfor applying Rehire Logic ChecksNode 1:Particpants present in FPRS Node 2 : Participants not present in FPRSGetting the row countand split as Row count >=2Row count < 2Row Count >=2implies it can have records 11,2D,61.Split into sets of 61 and 11,2DChecks for RowcountIf Rowcount =2 , it has both 11 and 2D RecordsRow count < 2implies it is misisng records 11,2D or 61Concat Records 11,2D and if present 61 These will be therecord set we usefro rehire LogicFilter Records that eithermiss a 11 or 2DCollecting the records for Plans thatmiss record 11 and 02DRead ClientIndicative Data FileAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredSplit Record 11's andRecord 02D,61for removing DuplicateRecord 11'sAll Recorfs thatpass thru rehire Logic02D,61,11after removing DuplicateRecord 11'sIdnetify DuplicateRecord 11'sNode 94Added a Column Reasonto provide a reasonwhy the record is filteredremove the column split and get the original dataas in fileAdded Status Columnwith Reason for FilteringNode 98Node 99Added Status Columnwith Reason for FilteringRemove Unwanted columnsSort Columnsfor reportCombine the Pass AS IS RecordsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredSplit :Record 02Dand 11,61Split :Record 11 andRecord 61Creating New Record 61Joining Record 11Node 131Node 132Newly createdRecord 61when FRPS_STATUS=TRecord 11Also Checks forFPRS Status =TConcat Pass-AS-ISRecord 11,61when FPRS Status != "T"Concat Ouput Test Case 1ARecord 2DRecord 11Record 61Check for FPRS Status =TNode 139Node 140Newly createdRecord 61Node 142Node 143FormattingNewly createdRecord 61for FPRS Status!=TNode 148Node 149Node 150Node 151Node 153Node 154Node 155Node 156FPRS Shell Account ExistsSplit for Record 11TypeN vs H,TFor creating test casesspecific to N,H,TNode 1 : Status = NNode 2 : Sttaus =H,TSplit :Record 02Dand 11,61Split :Record 11 andRecord 61Node 161Updated Record 11 outputNode 163Node 164Newly createdRecord 61for FPRS Status!=TUpdatedRecord 2D OutputNode 167Node 171Node 172Newly createdRecord 61Node 175Record 61Also Check for FPRS Status =TSplit Record 11by cell positionsConcat Ouput Test Case 1BRecord 2DRecord 11Record 61Concat Pass-AS-ISRecord 11,61when FPRS Status != "T"Record 11Also checks forFPRS Status =TNewly createdRecord 61when FRPS_STATUS=TSplit Record 02Dby cell positions Split Test Casesfor 1A and 1BSplit Record 61by cell positionsSplit Record 61by cell positionsNode 210Node 215Node 216Node 217Added a Column Reasonto provide a reasonwhy the record is filteredremove unwantedcoulmnsAdded Status Columnwith Reason for FilteringAdded Status Columnwith Reason for Filteringremove unwantedcolumnsAdded a Column Reasonto provide a reasonwhy the record is filteredremove unwantedcolumnsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredNode 227Added Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredremove unwantedcolumnsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredNode 234Node 235UpdatedRecord 2D Outputremove unwantedcolumnsAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringNode 240Split Record 02Dby cell positionsNode 242remove unwantedcolumnsAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringSplit Record 11by cell positionsNode 247Updated Record 11 outputremove unwantedcolumnsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredRename columnRecord 02DOutput Record 2D for Test Case 1CAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredConcat Ouput Test Case 1CRecord 2DRecord 11Record 61FPRS Shell Account does not ExistsSplit for Record 11Type N vs H,TFor creating test casesspecific to N,H,TNode 1 : Status = NNode 2 : Sttaus =H,T Split Test Casesfor 1C and 1DSplit :Record 02Dand 11,61Added a Column Reasonto provide a reasonwhy the record is filteredRecord 11Added Status Columnwith Reason for FilteringOutput Record 11 for Test Case 1CSplit :Record 11 andRecord 61Creating New Record 61Joining Record 11Added Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredremove unwantedcoulmnsReplacing string 11N with 61Created New Record 61Split :Record 02Dand 11,61Record 02DSplit :Record 11 andRecord 61Added a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringOutput Record 2D for Test Case 1DConcat Ouput Test Case 1DRecord 2DRecord 11Record 61Added a Column Reasonto provide a reasonwhy the record is filteredOutput Record 11 for Test Case 1DAdded Status Columnwith Reason for FilteringRecord 11Record 61Output Record 61for Test Case 1DRecord 61D for Test Case 1DAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredFPRS Shell Account ExistsSplit for Record 11TypeH VS TFor creating test casesspecific to H,TNode 1 : Status = HNode 2 : Sttaus =TRehire with FPRS Shell Account Split Test Casesfor 2C and 2DNode 1 :Test Case 2CNode 2 : Test Case 2DRehire, with FPRS Shell accountand Record 61 PresentSplit :Record 02Dand 11,61Node 1: 02 RecordNode 2: 11,61Rehire, with FPRS Shell accountand Record 61 is not PresentSplit :Record 02Dand 11,61Node 1: 02 RecordNode 2: 11,61Record 02DAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredOutput Record 2D for Test Case 2CAdded Status Columnwith Reason for FilteringRecord 02DOutput Record 2D for Test Case 2DAdded a Column Reasonto provide a reasonwhy the record is filteredConcat Ouput Test Case 2CRecord 2DRecord 11Record 61Record 11Split :Record 11 andRecord 61Record 61Added Status Columnwith Reason for FilteringOutput Record 11 for Test Case 2CAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredOutput Record 61 for Test Case 2CConcat Ouput Test Case 2DRecord 2DRecord 11Record 61Split :Record 11 andRecord 61Record 11Added Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredOutput Record 11 for Test Case 2DAdded Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredReplacing string 11N with 61Creating New Record 61Joining Record 11Created New Record 61 FPRS Shell Account does not Exists Split Record 11Type H,TNode 1 : Status = HNode 2 : Sttaus = TRehire without FPRS ShellSSN presnt in Historic DatabaseNode 1:Record 61 ExistsNode 2 : Record 61 not sentTest Cases Split for Test Case 2E,2FRehire, FPRS Shell not existsJoining the Rehire, FPRS Not existsRecords with Historic DB Recordsfor Checking if SSN is Present in Historic DB or notNode 1:Particpants not present in FPRS, but present in Hist DB (2E,2F)Node 2 : Participants not present in FPRS and also not in Hist DB(2A,2B)Rehire without FPRS ShellSSN not presnt in Historic DatabaseNode 1:Record 61 ExistsNode 2 : Record 61 not sentTest Cases Split for Test Case 2A,2BTest Case : 2ARehireNo FPRS ShellSSN NOT in Hist DBRecord 61 Exists Node 1: Record 02DNode 2 : 11,61Test Case : 2BRehireNo FPRS ShellSSN NOT in Hist DBRecord 61 not Exists Node 1: Record 02DNode 2 : 11remove unwantedcolumnsAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringSplit :Record 11 andRecord 61Added a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringRecord 11Concat Ouput Test Case 2ARecord 2DRecord 11Record 61Update Status from H to NRecord 11 outputAdded Status Columnwith Reason for Filteringcombine ADOH from Rrcord 61with Record 02Split Record 61by cell positionsremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredNode 389Output Record 61for Test Case 2ARecord 61Record 02Output Record 02for Test Case 2ASplit Record 02by cell positionsCheck for ADODfor zerofill,spacefillVs having a valueNode 1 : ADOH not Zerfill or spacefillNode 2: ADOH is zerofill, spacefillRecord 02Pass As ISAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringConcate to get Record 02 forTest Caee 2AOutput Record 02for Test Case 2ARecord 02Record 11Added Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredOutput Record 02for Test Case 2ARecord 11 outputUpdate Status from H to NAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredConcat Ouput Test Case 2BRecord 2DRecord 11Record 61Added a Column Reasonto provide a reasonwhy the record is filteredCreate Record 61 using Record 11Replacing string 11N with 61Created New Record 61remove unwantedcoulmnsAdded Status Columnwith Reason for FilteringSplit : Record 02Dand 11,61Node 1: 02 RecordNode 2: 11,61Split :Record 11 andRecord 61Record 11Record 61Day 1: Record 11 outputUpdate Status from H to NAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredConcat Ouput Test Case 2E : Day 1Record 2DRecord 11Record 61remove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredDay 1 :Output Record 61for Test Case 2EAdded Status Columnwith Reason for FilteringRecord 02Replace Hire Datefrom DatabaseHire Date format changeRemove timestamp from Hire_DT and Term_DTTerm_DateFormat changeRemove space from end Replace Term Datefrom DatabaseRename columnDay 1: Record 02 OutputAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringConcat Ouput Test Case 2E : Day 2Record 2DRecord 11Record 61Update Status from H to NDay 2 : Record 11 OutputAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredDay 2: Record 02 OutputRename columnAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringNode 453Record 02 DOHfetch DOH from Record 02Node 456Day 2:Output Record 61Added Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredSplit : Record 02Dand 11,61Node 1: 02 RecordNode 2: 11,61Rename columnAdded a Column Reasonto provide a reasonwhy the record is filteredRename columnAdded a Column Reasonto provide a reasonwhy the record is filteredDay 1: Record 02 OutputAdded Status Columnwith Reason for FilteringRecord 02Added Status Columnwith Reason for FilteringHire Date format changeReplace Hire Datefrom DatabaseTerm_DateFormat changeRemove timestamp from Hire_DT and Term_DTReplace Term Datefrom DatabaseRemove space from end Day 2: Record 02 OutputConcat Ouput Test Case 2F : Day 1Record 2DRecord 11Record 61Node 478Record 02 DOHRecord 11Update Status from H to NDay 2 : Record 11 OutputDay 1: Record 11 outputUpdate Status from H to NAdded a Column Reasonto provide a reasonwhy the record is filteredAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringAdded Status Columnwith Reason for FilteringConcat Ouput Test Case 2F : Day 2Record 2DRecord 11Record 61Create Record 61 using Record 11Replacing string 11H with 61Record 61Added Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredModifying Record 61Day 1 :Output Record 61for Test Case 2Ffetch DOH from Record 02Day2 : Record 61remove unwantedcoulmnsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredFPRS Shell does not exsistRecord Type =TNode 505Node 506Added a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringConact Pass-As-IS andMissing 11 and 02Test Case 1 RecordsTest Case 1 RecordsNode 515Node 516Node 517Node 518Node 519Final OutputNode 522Node 523Node 526Node 527 Rule-basedRow Filter Cell SplitterBy Position Rule-basedRow Filter Rule-basedRow Splitter Concatenate Column Filter Rule-basedRow Splitter Column Filter Group Loop Start Joiner Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Column Filter Concatenate Column Filter Concatenate Line Reader ConstantValue Column ConstantValue Column Rule-basedRow Splitter Concatenate DuplicateRow Filter Rule-basedRow Splitter ConstantValue Column Column Filter ConstantValue Column Rule-basedRow Splitter Rule Engine ConstantValue Column Column Filter Column Resorter Concatenate ConstantValue Column ConstantValue Column Rule-basedRow Splitter Rule-basedRow Splitter Joiner Rule Engine String Manipulation String Manipulation Rule-basedRow Splitter Concatenate Concatenate Rule-basedRow Splitter String Manipulation String Manipulation String Manipulation String Manipulation Rule Engine String Manipulation String Manipulation Sorter GroupBy Row Filter Column Appender Rule Engine Group Loop Start Loop End Table Rowto Variable Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter String Manipulation Column Combiner String Manipulation Column Combiner String Manipulation String Manipulation String Manipulation Date&Time to String String Manipulation String Manipulation String Manipulation Rule-basedRow Splitter Cell SplitterBy Position Concatenate Concatenate Rule-basedRow Splitter String Manipulation Cell SplitterBy Position Rule-basedRow Splitter Cell SplitterBy Position Cell SplitterBy Position Column Combiner Joiner Column Combiner Column Resorter ConstantValue Column Column Filter ConstantValue Column ConstantValue Column Column Filter ConstantValue Column Column Filter ConstantValue Column ConstantValue Column Column Resorter ConstantValue Column Column Filter ConstantValue Column Column Filter ConstantValue Column ConstantValue Column String Manipulation Column Combiner String Manipulation Column Filter ConstantValue Column ConstantValue Column Column Resorter Cell SplitterBy Position Date&Time to String Column Filter ConstantValue Column ConstantValue Column Cell SplitterBy Position String Manipulation Column Combiner Column Filter ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Column Filter ConstantValue Column Column Filter ConstantValue Column Column Rename Column Filter Column Rename ConstantValue Column ConstantValue Column Concatenate Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter ConstantValue Column Column Filter ConstantValue Column Column Rename Rule-basedRow Splitter Joiner ConstantValue Column ConstantValue Column Column Filter Column Expressions Column Expressions Rule-basedRow Splitter Column Filter Rule-basedRow Splitter ConstantValue Column ConstantValue Column Column Rename Concatenate ConstantValue Column Column Rename ConstantValue Column Column Filter Column Filter Column Expressions Column Filter ConstantValue Column ConstantValue Column Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Column Filter ConstantValue Column ConstantValue Column Column Rename ConstantValue Column Column Filter Column Rename ConstantValue Column Concatenate Column Filter Rule-basedRow Splitter Column Filter ConstantValue Column Column Rename ConstantValue Column ConstantValue Column ConstantValue Column Column Rename Concatenate Rule-basedRow Splitter Column Filter ConstantValue Column ConstantValue Column Column Rename ConstantValue Column Column Filter ConstantValue Column Column Expressions Joiner Column Expressions Rule-basedRow Splitter Rule-basedRow Splitter Joiner Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Column Filter ConstantValue Column ConstantValue Column Rule-basedRow Splitter ConstantValue Column ConstantValue Column Column Filter Concatenate String Manipulation Column Filter ConstantValue Column Joiner Cell SplitterBy Position Column Filter ConstantValue Column Column Filter Column Expressions Column Filter Column Filter Column Expressions Cell SplitterBy Position Rule-basedRow Splitter Column Filter ConstantValue Column ConstantValue Column Concatenate Column Rename Column Filter Column Filter ConstantValue Column ConstantValue Column Column Rename Column Filter String Manipulation ConstantValue Column ConstantValue Column Concatenate ConstantValue Column Column Expressions Column Expressions Column Filter ConstantValue Column Rule-basedRow Splitter Rule-basedRow Splitter Column Filter Column Filter Column Filter String Manipulation ConstantValue Column ConstantValue Column Concatenate Column Filter ConstantValue Column Column Expressions ConstantValue Column Column Filter Column Expressions String Manipulation Date&Time to String String Manipulation Column Expressions Column Expressions Column Rename Column Filter ConstantValue Column ConstantValue Column Concatenate String Manipulation Column Expressions ConstantValue Column ConstantValue Column Column Filter Column Rename ConstantValue Column ConstantValue Column Cell SplitterBy Position Column Filter Joiner Column Expressions Column Expressions ConstantValue Column Column Filter ConstantValue Column Rule-basedRow Splitter Column Rename ConstantValue Column Column Rename ConstantValue Column Column Filter ConstantValue Column Column Filter ConstantValue Column String Manipulation Column Expressions String Manipulation Date&Time to String Column Expressions Column Expressions Column Filter Concatenate Cell SplitterBy Position Column Filter Column Filter String Manipulation Column Expressions Column Filter String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Concatenate Column Expressions Column Filter ConstantValue Column Column Filter ConstantValue Column Column Expressions Column Expressions Joiner Column Expressions Column Filter ConstantValue Column ConstantValue Column Column Filter Column Filter Column Rename ConstantValue Column ConstantValue Column Row Count Concatenate Concatenate Concatenate Concatenate Concatenate Concatenate Concatenate Column Filter Concatenate Loop End CSV Writer CSV Reader CSV Reader Step 2 : PASS AS IS Records Step 3 : Filter Duplicate Records Rehire Logic PASS AS IS PLANS Work flow: 1A Record Type =11N FPRS Shell Account ExistsFPRS Status Code =TRecord 61 not sentMissing Record 61 Work flow: 1B Record Type =11N FPRS Shell Account existsFPRS Status Code =TRecord 61 is sentMissing Record 61 Work flow: 1C Record Type =11N FPRS Shell Account does not existsRecord 61 is not sent Work flow: 1D Record Type =11N FPRS Shell Account does not existsRecord 61 is sent Work flow: 2C Record Type =11H FPRS Shell Account existsRecord 61 is sentNo change, o2,11 and 61 Pass AS IS Work flow: 2D Record Type =11H FPRS Shell Account existsRecord 61 is not sentNio change to Record 02,11 nd creae a zerofill Record 61 Work flow: 2A Record Type =11H FPRS Shell Account does not existsSSN Not present in Hist DBRecord 61 ExistsNio change to Record 02,11 nd creae a zerofill Record 61 Work flow: 2E Record Type =11H FPRS Shell Account does not existsSSN Presnt in Historic DBRecord 61 is sentNio change to Record 02,11 nd creae a zerofill Record 61 Work flow: 2F Record Type =11H FPRS Shell Account does not existsSSN Presnt in Historic DBRecord 61 not sentNio change to Record 02,11 nd creae a zerofill Record 61 Work flow: 2B Record Type =11H FPRS Shell Account does not existsSSN Not present in Hist DBRecord 61 is not sent, create a zerofill record 61Nio change to Record 02,11 nd creae a zerofill Record 61 Test Case 2E Day 1 Report Test Case 2E Day 2 Report Test Case 2F Day 1 Report Test Case 2F Day 2 Report Work flow: 3A,3B Record Type =11T FPRS Shell Account does not existsRecord 61 sent or not sent : Remove Records Filter Invalid Record TypesSplit the Recordsto columnsFilter Invalid and Misisng Plan numbersSplitting Plans Pass AS ISand Plans that go thru Rehire LogicCombine the PASS AS IS RecordsDuplicate 11 removedremove the column split and get the original dataas in filePlans Eligible forRehire Logic: Split the PASS AS IS Record Typesand Records that gothru Rehire Logic 02D,11,61remove the column splitand get the original dataas in fileFetching a setof records per SSN and PlanJoining the Rehire Logic Records with FPRS Recordsfor applying Rehire Logic ChecksNode 1:Particpants present in FPRS Node 2 : Participants not present in FPRSGetting the row countand split as Row count >=2Row count < 2Row Count >=2implies it can have records 11,2D,61.Split into sets of 61 and 11,2DChecks for RowcountIf Rowcount =2 , it has both 11 and 2D RecordsRow count < 2implies it is misisng records 11,2D or 61Concat Records 11,2D and if present 61 These will be therecord set we usefro rehire LogicFilter Records that eithermiss a 11 or 2DCollecting the records for Plans thatmiss record 11 and 02DRead ClientIndicative Data FileAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredSplit Record 11's andRecord 02D,61for removing DuplicateRecord 11'sAll Recorfs thatpass thru rehire Logic02D,61,11after removing DuplicateRecord 11'sIdnetify DuplicateRecord 11'sNode 94Added a Column Reasonto provide a reasonwhy the record is filteredremove the column split and get the original dataas in fileAdded Status Columnwith Reason for FilteringNode 98Node 99Added Status Columnwith Reason for FilteringRemove Unwanted columnsSort Columnsfor reportCombine the Pass AS IS RecordsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredSplit :Record 02Dand 11,61Split :Record 11 andRecord 61Creating New Record 61Joining Record 11Node 131Node 132Newly createdRecord 61when FRPS_STATUS=TRecord 11Also Checks forFPRS Status =TConcat Pass-AS-ISRecord 11,61when FPRS Status != "T"Concat Ouput Test Case 1ARecord 2DRecord 11Record 61Check for FPRS Status =TNode 139Node 140Newly createdRecord 61Node 142Node 143FormattingNewly createdRecord 61for FPRS Status!=TNode 148Node 149Node 150Node 151Node 153Node 154Node 155Node 156FPRS Shell Account ExistsSplit for Record 11TypeN vs H,TFor creating test casesspecific to N,H,TNode 1 : Status = NNode 2 : Sttaus =H,TSplit :Record 02Dand 11,61Split :Record 11 andRecord 61Node 161Updated Record 11 outputNode 163Node 164Newly createdRecord 61for FPRS Status!=TUpdatedRecord 2D OutputNode 167Node 171Node 172Newly createdRecord 61Node 175Record 61Also Check for FPRS Status =TSplit Record 11by cell positionsConcat Ouput Test Case 1BRecord 2DRecord 11Record 61Concat Pass-AS-ISRecord 11,61when FPRS Status != "T"Record 11Also checks forFPRS Status =TNewly createdRecord 61when FRPS_STATUS=TSplit Record 02Dby cell positions Split Test Casesfor 1A and 1BSplit Record 61by cell positionsSplit Record 61by cell positionsNode 210Node 215Node 216Node 217Added a Column Reasonto provide a reasonwhy the record is filteredremove unwantedcoulmnsAdded Status Columnwith Reason for FilteringAdded Status Columnwith Reason for Filteringremove unwantedcolumnsAdded a Column Reasonto provide a reasonwhy the record is filteredremove unwantedcolumnsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredNode 227Added Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredremove unwantedcolumnsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredNode 234Node 235UpdatedRecord 2D Outputremove unwantedcolumnsAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringNode 240Split Record 02Dby cell positionsNode 242remove unwantedcolumnsAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringSplit Record 11by cell positionsNode 247Updated Record 11 outputremove unwantedcolumnsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredRename columnRecord 02DOutput Record 2D for Test Case 1CAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredConcat Ouput Test Case 1CRecord 2DRecord 11Record 61FPRS Shell Account does not ExistsSplit for Record 11Type N vs H,TFor creating test casesspecific to N,H,TNode 1 : Status = NNode 2 : Sttaus =H,T Split Test Casesfor 1C and 1DSplit :Record 02Dand 11,61Added a Column Reasonto provide a reasonwhy the record is filteredRecord 11Added Status Columnwith Reason for FilteringOutput Record 11 for Test Case 1CSplit :Record 11 andRecord 61Creating New Record 61Joining Record 11Added Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredremove unwantedcoulmnsReplacing string 11N with 61Created New Record 61Split :Record 02Dand 11,61Record 02DSplit :Record 11 andRecord 61Added a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringOutput Record 2D for Test Case 1DConcat Ouput Test Case 1DRecord 2DRecord 11Record 61Added a Column Reasonto provide a reasonwhy the record is filteredOutput Record 11 for Test Case 1DAdded Status Columnwith Reason for FilteringRecord 11Record 61Output Record 61for Test Case 1DRecord 61D for Test Case 1DAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredFPRS Shell Account ExistsSplit for Record 11TypeH VS TFor creating test casesspecific to H,TNode 1 : Status = HNode 2 : Sttaus =TRehire with FPRS Shell Account Split Test Casesfor 2C and 2DNode 1 :Test Case 2CNode 2 : Test Case 2DRehire, with FPRS Shell accountand Record 61 PresentSplit :Record 02Dand 11,61Node 1: 02 RecordNode 2: 11,61Rehire, with FPRS Shell accountand Record 61 is not PresentSplit :Record 02Dand 11,61Node 1: 02 RecordNode 2: 11,61Record 02DAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredOutput Record 2D for Test Case 2CAdded Status Columnwith Reason for FilteringRecord 02DOutput Record 2D for Test Case 2DAdded a Column Reasonto provide a reasonwhy the record is filteredConcat Ouput Test Case 2CRecord 2DRecord 11Record 61Record 11Split :Record 11 andRecord 61Record 61Added Status Columnwith Reason for FilteringOutput Record 11 for Test Case 2CAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredOutput Record 61 for Test Case 2CConcat Ouput Test Case 2DRecord 2DRecord 11Record 61Split :Record 11 andRecord 61Record 11Added Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredOutput Record 11 for Test Case 2DAdded Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredReplacing string 11N with 61Creating New Record 61Joining Record 11Created New Record 61 FPRS Shell Account does not Exists Split Record 11Type H,TNode 1 : Status = HNode 2 : Sttaus = TRehire without FPRS ShellSSN presnt in Historic DatabaseNode 1:Record 61 ExistsNode 2 : Record 61 not sentTest Cases Split for Test Case 2E,2FRehire, FPRS Shell not existsJoining the Rehire, FPRS Not existsRecords with Historic DB Recordsfor Checking if SSN is Present in Historic DB or notNode 1:Particpants not present in FPRS, but present in Hist DB (2E,2F)Node 2 : Participants not present in FPRS and also not in Hist DB(2A,2B)Rehire without FPRS ShellSSN not presnt in Historic DatabaseNode 1:Record 61 ExistsNode 2 : Record 61 not sentTest Cases Split for Test Case 2A,2BTest Case : 2ARehireNo FPRS ShellSSN NOT in Hist DBRecord 61 Exists Node 1: Record 02DNode 2 : 11,61Test Case : 2BRehireNo FPRS ShellSSN NOT in Hist DBRecord 61 not Exists Node 1: Record 02DNode 2 : 11remove unwantedcolumnsAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringSplit :Record 11 andRecord 61Added a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringRecord 11Concat Ouput Test Case 2ARecord 2DRecord 11Record 61Update Status from H to NRecord 11 outputAdded Status Columnwith Reason for Filteringcombine ADOH from Rrcord 61with Record 02Split Record 61by cell positionsremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredNode 389Output Record 61for Test Case 2ARecord 61Record 02Output Record 02for Test Case 2ASplit Record 02by cell positionsCheck for ADODfor zerofill,spacefillVs having a valueNode 1 : ADOH not Zerfill or spacefillNode 2: ADOH is zerofill, spacefillRecord 02Pass As ISAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringConcate to get Record 02 forTest Caee 2AOutput Record 02for Test Case 2ARecord 02Record 11Added Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredOutput Record 02for Test Case 2ARecord 11 outputUpdate Status from H to NAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredConcat Ouput Test Case 2BRecord 2DRecord 11Record 61Added a Column Reasonto provide a reasonwhy the record is filteredCreate Record 61 using Record 11Replacing string 11N with 61Created New Record 61remove unwantedcoulmnsAdded Status Columnwith Reason for FilteringSplit : Record 02Dand 11,61Node 1: 02 RecordNode 2: 11,61Split :Record 11 andRecord 61Record 11Record 61Day 1: Record 11 outputUpdate Status from H to NAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredConcat Ouput Test Case 2E : Day 1Record 2DRecord 11Record 61remove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredDay 1 :Output Record 61for Test Case 2EAdded Status Columnwith Reason for FilteringRecord 02Replace Hire Datefrom DatabaseHire Date format changeRemove timestamp from Hire_DT and Term_DTTerm_DateFormat changeRemove space from end Replace Term Datefrom DatabaseRename columnDay 1: Record 02 OutputAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringConcat Ouput Test Case 2E : Day 2Record 2DRecord 11Record 61Update Status from H to NDay 2 : Record 11 OutputAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredDay 2: Record 02 OutputRename columnAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringNode 453Record 02 DOHfetch DOH from Record 02Node 456Day 2:Output Record 61Added Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredSplit : Record 02Dand 11,61Node 1: 02 RecordNode 2: 11,61Rename columnAdded a Column Reasonto provide a reasonwhy the record is filteredRename columnAdded a Column Reasonto provide a reasonwhy the record is filteredDay 1: Record 02 OutputAdded Status Columnwith Reason for FilteringRecord 02Added Status Columnwith Reason for FilteringHire Date format changeReplace Hire Datefrom DatabaseTerm_DateFormat changeRemove timestamp from Hire_DT and Term_DTReplace Term Datefrom DatabaseRemove space from end Day 2: Record 02 OutputConcat Ouput Test Case 2F : Day 1Record 2DRecord 11Record 61Node 478Record 02 DOHRecord 11Update Status from H to NDay 2 : Record 11 OutputDay 1: Record 11 outputUpdate Status from H to NAdded a Column Reasonto provide a reasonwhy the record is filteredAdded a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringAdded Status Columnwith Reason for FilteringConcat Ouput Test Case 2F : Day 2Record 2DRecord 11Record 61Create Record 61 using Record 11Replacing string 11H with 61Record 61Added Status Columnwith Reason for Filteringremove unwantedcoulmnsAdded a Column Reasonto provide a reasonwhy the record is filteredModifying Record 61Day 1 :Output Record 61for Test Case 2Ffetch DOH from Record 02Day2 : Record 61remove unwantedcoulmnsAdded Status Columnwith Reason for FilteringAdded a Column Reasonto provide a reasonwhy the record is filteredFPRS Shell does not exsistRecord Type =TNode 505Node 506Added a Column Reasonto provide a reasonwhy the record is filteredAdded Status Columnwith Reason for FilteringConact Pass-As-IS andMissing 11 and 02Test Case 1 RecordsTest Case 1 RecordsNode 515Node 516Node 517Node 518Node 519Final OutputNode 522Node 523Node 526Node 527Rule-basedRow Filter Cell SplitterBy Position Rule-basedRow Filter Rule-basedRow Splitter Concatenate Column Filter Rule-basedRow Splitter Column Filter Group Loop Start Joiner Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Column Filter Concatenate Column Filter Concatenate Line Reader ConstantValue Column ConstantValue Column Rule-basedRow Splitter Concatenate DuplicateRow Filter Rule-basedRow Splitter ConstantValue Column Column Filter ConstantValue Column Rule-basedRow Splitter Rule Engine ConstantValue Column Column Filter Column Resorter Concatenate ConstantValue Column ConstantValue Column Rule-basedRow Splitter Rule-basedRow Splitter Joiner Rule Engine String Manipulation String Manipulation Rule-basedRow Splitter Concatenate Concatenate Rule-basedRow Splitter String Manipulation String Manipulation String Manipulation String Manipulation Rule Engine String Manipulation String Manipulation Sorter GroupBy Row Filter Column Appender Rule Engine Group Loop Start Loop End Table Rowto Variable Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter String Manipulation Column Combiner String Manipulation Column Combiner String Manipulation String Manipulation String Manipulation Date&Time to String String Manipulation String Manipulation String Manipulation Rule-basedRow Splitter Cell SplitterBy Position Concatenate Concatenate Rule-basedRow Splitter String Manipulation Cell SplitterBy Position Rule-basedRow Splitter Cell SplitterBy Position Cell SplitterBy Position Column Combiner Joiner Column Combiner Column Resorter ConstantValue Column Column Filter ConstantValue Column ConstantValue Column Column Filter ConstantValue Column Column Filter ConstantValue Column ConstantValue Column Column Resorter ConstantValue Column Column Filter ConstantValue Column Column Filter ConstantValue Column ConstantValue Column String Manipulation Column Combiner String Manipulation Column Filter ConstantValue Column ConstantValue Column Column Resorter Cell SplitterBy Position Date&Time to String Column Filter ConstantValue Column ConstantValue Column Cell SplitterBy Position String Manipulation Column Combiner Column Filter ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Column Filter ConstantValue Column Column Filter ConstantValue Column Column Rename Column Filter Column Rename ConstantValue Column ConstantValue Column Concatenate Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter ConstantValue Column Column Filter ConstantValue Column Column Rename Rule-basedRow Splitter Joiner ConstantValue Column ConstantValue Column Column Filter Column Expressions Column Expressions Rule-basedRow Splitter Column Filter Rule-basedRow Splitter ConstantValue Column ConstantValue Column Column Rename Concatenate ConstantValue Column Column Rename ConstantValue Column Column Filter Column Filter Column Expressions Column Filter ConstantValue Column ConstantValue Column Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Column Filter ConstantValue Column ConstantValue Column Column Rename ConstantValue Column Column Filter Column Rename ConstantValue Column Concatenate Column Filter Rule-basedRow Splitter Column Filter ConstantValue Column Column Rename ConstantValue Column ConstantValue Column ConstantValue Column Column Rename Concatenate Rule-basedRow Splitter Column Filter ConstantValue Column ConstantValue Column Column Rename ConstantValue Column Column Filter ConstantValue Column Column Expressions Joiner Column Expressions Rule-basedRow Splitter Rule-basedRow Splitter Joiner Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Column Filter ConstantValue Column ConstantValue Column Rule-basedRow Splitter ConstantValue Column ConstantValue Column Column Filter Concatenate String Manipulation Column Filter ConstantValue Column Joiner Cell SplitterBy Position Column Filter ConstantValue Column Column Filter Column Expressions Column Filter Column Filter Column Expressions Cell SplitterBy Position Rule-basedRow Splitter Column Filter ConstantValue Column ConstantValue Column Concatenate Column Rename Column Filter Column Filter ConstantValue Column ConstantValue Column Column Rename Column Filter String Manipulation ConstantValue Column ConstantValue Column Concatenate ConstantValue Column Column Expressions Column Expressions Column Filter ConstantValue Column Rule-basedRow Splitter Rule-basedRow Splitter Column Filter Column Filter Column Filter String Manipulation ConstantValue Column ConstantValue Column Concatenate Column Filter ConstantValue Column Column Expressions ConstantValue Column Column Filter Column Expressions String Manipulation Date&Time to String String Manipulation Column Expressions Column Expressions Column Rename Column Filter ConstantValue Column ConstantValue Column Concatenate String Manipulation Column Expressions ConstantValue Column ConstantValue Column Column Filter Column Rename ConstantValue Column ConstantValue Column Cell SplitterBy Position Column Filter Joiner Column Expressions Column Expressions ConstantValue Column Column Filter ConstantValue Column Rule-basedRow Splitter Column Rename ConstantValue Column Column Rename ConstantValue Column Column Filter ConstantValue Column Column Filter ConstantValue Column String Manipulation Column Expressions String Manipulation Date&Time to String Column Expressions Column Expressions Column Filter Concatenate Cell SplitterBy Position Column Filter Column Filter String Manipulation Column Expressions Column Filter String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Concatenate Column Expressions Column Filter ConstantValue Column Column Filter ConstantValue Column Column Expressions Column Expressions Joiner Column Expressions Column Filter ConstantValue Column ConstantValue Column Column Filter Column Filter Column Rename ConstantValue Column ConstantValue Column Row Count Concatenate Concatenate Concatenate Concatenate Concatenate Concatenate Concatenate Column Filter Concatenate Loop End CSV Writer CSV Reader CSV Reader

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: a743863
Created at: 2023-04-14
On NodePit since: 2023-05-03
Last update: 2024-04-27
Created with KNIME version: v4.7.1

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

Try NodePit Runner!