Icon

Test Google Connection.knar

GET DATA FROM PREVIOUS CYCLEPAYROLL DATA FROM COUNTRY FILES GOOGLE SHEETSCONNECTIONSIGN IN TO GOOGLE GET DATA FROM CURRENT CYCLEBRING THE PAYROLL FILE PROVIDED BY PRODUCT TEAM QA FLAG NEW EMPLOYEE FLAG SALARY CHANGE EMPTY COLUMNS GET DATA FROM ALL ACTIVE EOREMPLOYEESIDEALLY WE WOULD RUN THEALL EORs QUERY DIRECTLYHERE MISSING/EXTRA EMPLOYEES GET DATA FROM TERMINATIONS DATES HANDLING GET DATA FROM CURRENT CYCLE -BONUSES Milestone Payroll Items QA Duplicate Signing bonus QA GET DATA FROM CANCELLATIONS Cancellations Terminations GET DATA FROM OFFCYCLE PAYMENTS GET DATA FROM DAYS_OFF TIME OFF Reading ProductPayroll File UPDATENode 2Node 3Node 10Node 12Node 13Notificationin Slackget files fromGoogle SheetsFile with listof all countryPayrollfiles TO BE UPDATEDFilter countrythat still don`thave a payrollfileNode 22OLD CYCLEFilter countriesthat have file butemptyADD TO LISTwait 2 secondswith tag"new employee"LIST OF INCORRECTTAGSNUMBER OF ISSUESNot newemployeesNode 35Node 36Node 37Node 38Node 39Node 40Node 41# ISSUESLIST OF INCORRECT TAGSwithout tag "new employee"NUMBER OF ISSUESList of ISSUESNUMBER OFISSUESNode 49Query allemployeesTO BE UPDATEDEXTRAMISSINGTerminationsEliminate blank rowsNode 56Node 57Node 58Run everytimeReading ProductPayroll FileUPDATENode 77LIST OFISSUESNode 79Node 80Node 81Node 82Node 83NUMBER OFISSUESWITH BONUS AND NOT NEW EMPLOYEENUMBER OFISSUESLIST OF ISSUESWITH SIGIN BONUSLAST CYCLE AND NEW CYCLECancellationsLIST OFISSUESShould it be by name?JoinerOnly Ready to process - In PayrollfileOnly Ready to process - notin payroll fileOnly Ready to process - allfrom TerminationsfileOff Cycle PaymentsDAYS OFFNode 99Node 104Node 118Node 120Node 121Node 122Countries withopen EORsCountries withopen EORsMISSING/EXTRA EMPLOYEESBY COUNTRYNode 126Node 127Node 128Node 129Node 136Provides startand sign thresholddatesGoogle SheetsReader Google SheetsConnection GoogleAuthentication Message Slackchannel Get Users Row Filter Message Slack User Google SheetsReader File Reader Row Filter Table Row ToVariable Loop Start Loop End Rule-basedRow Filter Wait... Rule-basedRow Filter Joiner GroupBy Rule-basedRow Filter Joiner Rule Engine String Manipulation String Manipulation String To Number Math Formula Math Formula GroupBy Joiner Rule-basedRow Filter GroupBy Row Filter GroupBy Rule Engine File Reader Joiner Joiner Google SheetsReader Row Filter Rule Engine String to Date&Time Row Filter Create Date&TimeRange Google SheetsReader Joiner Rule Engine String To Number String Manipulation String Manipulation Math Formula Math Formula GroupBy Rule-basedRow Filter GroupBy Rule-basedRow Filter Joiner Google SheetsReader Joiner Joiner Row Filter Row Filter Row Filter Google SheetsReader Google SheetsReader Joiner Rule Engine Joiner Joiner Rule Engine String to Date&Time GroupBy GroupBy Joiner DB Table Selector DB Reader Snowflake Connector Send Email Cycles Namesand dates Dates Handling GET DATA FROM PREVIOUS CYCLEPAYROLL DATA FROM COUNTRY FILES GOOGLE SHEETSCONNECTIONSIGN IN TO GOOGLE GET DATA FROM CURRENT CYCLEBRING THE PAYROLL FILE PROVIDED BY PRODUCT TEAM QA FLAG NEW EMPLOYEE FLAG SALARY CHANGE EMPTY COLUMNS GET DATA FROM ALL ACTIVE EOREMPLOYEESIDEALLY WE WOULD RUN THEALL EORs QUERY DIRECTLYHERE MISSING/EXTRA EMPLOYEES GET DATA FROM TERMINATIONS DATES HANDLING GET DATA FROM CURRENT CYCLE -BONUSES Milestone Payroll Items QA Duplicate Signing bonus QA GET DATA FROM CANCELLATIONS Cancellations Terminations GET DATA FROM OFFCYCLE PAYMENTS GET DATA FROM DAYS_OFF TIME OFF Reading ProductPayroll File UPDATENode 2Node 3Node 10Node 12Node 13Notificationin Slackget files fromGoogle SheetsFile with listof all countryPayrollfiles TO BE UPDATEDFilter countrythat still don`thave a payrollfileNode 22OLD CYCLEFilter countriesthat have file butemptyADD TO LISTwait 2 secondswith tag"new employee"LIST OF INCORRECTTAGSNUMBER OF ISSUESNot newemployeesNode 35Node 36Node 37Node 38Node 39Node 40Node 41# ISSUESLIST OF INCORRECT TAGSwithout tag "new employee"NUMBER OF ISSUESList of ISSUESNUMBER OFISSUESNode 49Query allemployeesTO BE UPDATEDEXTRAMISSINGTerminationsEliminate blank rowsNode 56Node 57Node 58Run everytimeReading ProductPayroll FileUPDATENode 77LIST OFISSUESNode 79Node 80Node 81Node 82Node 83NUMBER OFISSUESWITH BONUS AND NOT NEW EMPLOYEENUMBER OFISSUESLIST OF ISSUESWITH SIGIN BONUSLAST CYCLE AND NEW CYCLECancellationsLIST OFISSUESShould it be by name?JoinerOnly Ready to process - In PayrollfileOnly Ready to process - notin payroll fileOnly Ready to process - allfrom TerminationsfileOff Cycle PaymentsDAYS OFFNode 99Node 104Node 118Node 120Node 121Node 122Countries withopen EORsCountries withopen EORsMISSING/EXTRA EMPLOYEESBY COUNTRYNode 126Node 127Node 128Node 129Node 136Provides startand sign thresholddatesGoogle SheetsReader Google SheetsConnection GoogleAuthentication Message Slackchannel Get Users Row Filter Message Slack User Google SheetsReader File Reader Row Filter Table Row ToVariable Loop Start Loop End Rule-basedRow Filter Wait... Rule-basedRow Filter Joiner GroupBy Rule-basedRow Filter Joiner Rule Engine String Manipulation String Manipulation String To Number Math Formula Math Formula GroupBy Joiner Rule-basedRow Filter GroupBy Row Filter GroupBy Rule Engine File Reader Joiner Joiner Google SheetsReader Row Filter Rule Engine String to Date&Time Row Filter Create Date&TimeRange Google SheetsReader Joiner Rule Engine String To Number String Manipulation String Manipulation Math Formula Math Formula GroupBy Rule-basedRow Filter GroupBy Rule-basedRow Filter Joiner Google SheetsReader Joiner Joiner Row Filter Row Filter Row Filter Google SheetsReader Google SheetsReader Joiner Rule Engine Joiner Joiner Rule Engine String to Date&Time GroupBy GroupBy Joiner DB Table Selector DB Reader Snowflake Connector Send Email Cycles Namesand dates Dates Handling

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: nicolasloterstein
Created at: 2022-01-11
On NodePit since: 2022-02-08
Last update: 2024-11-24
Created with KNIME version: v4.5.0

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

Try NodePit Runner!