Icon

Provider Onboarding

QuickSight Filter Extract

Convert Output FilePath Variable into Path Variable
String to Path (Variable)
Convert number columnsto string format
Number to String
Match applicable ORG IDsfor Maya Provider Onboarding
Joiner
Match applicable ORG IDsfor GCash Provider Onboarding
Joiner
Read QuickSight Extractfor Maya Data
CSV Reader
Read QuickSight Extractfor GCash Data
CSV Reader
Read template for Maya Output
Google Sheets Reader
Add Count column
String Manipulation
Map MCC tocorresponding mID
Joiner
Rename columns forMAYA template
Column Renamer
Add MID RequestCount column
String Manipulation
Generate today's date
Date&Time Configuration
Convert today's dateinto String
Date&Time to String
Add PayMaya statuscolumn
String Manipulation
Convert today's dateinto manipulable data
Variable to Table Column
Convert MCC to String
Number to String
Convert today's dateinto DateTime format
String to Date&Time
Align columns totemplate formatting
Concatenate
Authorize GoogleCredentials
Google Authenticator
Authorize GoogleSheets
Google Sheets Connector
Select UB tabof PartnersOnboarding RequestGoogle Sheet
Google Sheets Reader
Filter forNon-Submitted Cases
Row Filter
Select MAYA tabof PartnersOnboarding RequestGoogle Sheet
Google Sheets Reader
Select GCASH tabof PartnersOnboarding RequestGoogle Sheet
Google Sheets Reader
Filter forNon-Submitted Cases
Row Filter
Output data in template format
Excel Writer
Read UBP tab of Master List(Copy of COMPLIANCE TEAM QUICK STAGING for Migration)
Google Sheets Reader
Append new merchantsinto template
Concatenate
Read GCash Category Tier Guide
Google Sheets Reader
Append batch number tooutput template header row
Column Appender
Isolate last rowof Master List
Rule-based Row Filter
Ungroup Listinto individual rows
Ungroup
Isolate header row of output template file
Row Filter
Convert cell of Sub Categoryinto List
Cell Splitter
Generate GCash Merchant IDfor corresponding Tier
Rule Engine
Match GCash Tier forcorresponding Sub Category
Joiner
Add batch number toheader title in header row
String Manipulation
Append new casesto Master List
Google Sheets Updater
Isolate column headers foroutput template file
Row Filter
Row Filter
Append new casesto Master List
Google Sheets Updater
Append new casesto Master List
Google Sheets Updater
Append header rowand column headers row
Concatenate
Create output file path
String Manipulation
Convert today's dateinto String
Date&Time to String
Generate today's date
Date&Time Configuration
Convert today's dateinto manipulable data
Variable to Table Column
Filter forNon-Submitted Cases
Row Filter
Add 1 to last batch number
Math Formula
Combine new cases
Concatenate
Isolate Output File Path column
Column Filter
Convert today's dateinto DateTime format
String to Date&Time
Isolate batch number
String to Number
Convert Output FilePath into Variable
Table Row to Variable
Rename columns to align withoutput template(up to 5th Incorporator)
Column Renamer
Resort columns
Column Resorter
Copy mid from Column Hto Column J
String Manipulation
Convert auto-populatedphone number to blankif Incorporator 1 is blank
Rule Engine
Populate "SHAREHOLDER"into Column T
String Manipulation
Convert auto-populatedemail to blankif Incorporator 2 is blank
Rule Engine
Convert auto-populatedphone number to blankif Incorporator 3 is blank
Rule Engine
Convert auto-populatedemail to blankif Incorporator 1 is blank
Rule Engine
Convert auto-populatedphone number to blankif Incorporator 2 is blank
Rule Engine
Convert auto-populatedphone number to blankif Incorporator 4 is blank
Rule Engine
Convert auto-populatedemail to blankif Incorporator 4 is blank
Rule Engine
Convert auto-populatedemail to blankif Incorporator 3 is blank
Rule Engine
Convert auto-populatedphone number to blankif Incorporator 6 is blank
Rule Engine
Convert auto-populatedemail to blankif Incorporator 6 is blank
Rule Engine
Convert auto-populatedphone number to blankif Incorporator 5 is blank
Rule Engine
Convert auto-populatedemail to blankif Incorporator 5 is blank
Rule Engine
Add 1 to each row indexto make first index 1
Math Formula
Add row index
Counter Generation
Sort columns based onincorporator descending
Sorter
Rename columnsfor GCash Output Template
Column Renamer
Map MCC tocorresponding mID
Joiner
Update Google Sheet with data
Google Sheets Updater
Read template for GCash Output
Google Sheets Reader
Convert today's dateinto manipulable data
Variable to Table Column
Convert Risk Levelto proper case
String Manipulation
Generate Yes/Nofor High RIsk
Rule Engine
Generate today's date
Date&Time Configuration
Convert today's dateinto DateTime format
String to Date&Time
Convert today's dateto proper date format
Date&Time to String
Align columns acrosstemplate and working file
Concatenate
Add 1 to eachcounter
Math Formula
Add counters forNo. column
Counter Generation
Convert Counterto String
Number to String
Filter for onlyORG ID column
Column Filter
Remove unnecessary columns
Column Filter
Update Google Sheet with data
Google Sheets Updater
Filter out GCash formatting
Row Filter
Read template for UB Output
Excel Reader
Match applicable ORG IDsfor UB Provider Onboarding
Joiner
Populate new ORG IDsto QS Filters tab ofPartners Onboarding Request
Google Sheets Updater
Remove blankColumn 0
Column Filter
Read QuickSight Extractfor Unionbank Data
CSV Reader
Convert MCCfrom String to Integer
String to Number
Remove duplicate MCC column
Column Filter
Read MCC to MIDmapping table
Google Sheets Reader
Map MCC tocorresponding mID
Joiner

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: genemichaelunabia
Created at: 2026-01-27
On NodePit since: 2026-02-11
Last update: 2026-02-11
Created with KNIME version: v5.8.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!