Icon

KNIME_​project task final - with BigQuery Lookup

Excel fileNode 4campaign id from bigqueryNode 11Node 13sorting Actedby and ActedAtinner join campaign idExclude original ActedBy and ActedAt using column selectionsgroup by campaignidLookup Campaign IDin BigQueryto see if presentCampaign Type (if ID found in BigQuery)Excel Reader (XLS)(deprecated) Excel Sheet Appender(XLS) (deprecated) Database Reader(legacy) Database Connector(legacy) String To Number Sorter Joiner GroupBy Cell Replacer Rule Engine Excel fileNode 4campaign id from bigqueryNode 11Node 13sorting Actedby and ActedAtinner join campaign idExclude original ActedBy and ActedAt using column selectionsgroup by campaignidLookup Campaign IDin BigQueryto see if presentCampaign Type (if ID found in BigQuery)Excel Reader (XLS)(deprecated) Excel Sheet Appender(XLS) (deprecated) Database Reader(legacy) Database Connector(legacy) String To Number Sorter Joiner GroupBy Cell Replacer Rule Engine

Nodes

Extensions

Links