Icon

FEATURE_​OMNI_​063 review

dfadfasdfasdfasdfsdf

ALTER TABLE FEATURE_OMNI_063

RENAME COLUMN TYPE TO FEATURE_OMNI_0839;

ALTER TABLE FEATURE_OMNI_063

RENAME COLUMN PLATFORM TO FEATURE_OMNI_0840;

ALTER TABLE FEATURE_OMNI_063

RENAME COLUMN MODEL TO FEATURE_OMNI_0841;

ALTER TABLE FEATURE_OMNI_063

RENAME COLUMN VENDOR TO FEATURE_OMNI_0842;

CREATE OR REPLACE TABLE FEATURE_OMNI_063 AS

SELECT DAY_ID, CUSTOMER_ID, FEATURE_OMNI_0842, FEATURE_OMNI_0841, FEATURE_OMNI_0840, FEATURE_OMNI_0839

FROM FEATURE_OMNI_063;

Map giá trị trong các biến FEATURE_OMNI_0840 và FEATURE_OMNI_0842 theo bảng lookup, convert data type sang integer
DB SQL Executor
Table Creator
FEATURE_OMNI_0842_LOOKUP
Table Creator
FEATURE_OMNI_0840_LOOKUP
Table Creator
Bảng lookup model - phân khúc
Table Creator
Tạo bảng FEATURE_OMNI_0840_LOOKUP
DB Writer
DB Table Selector
-- Load file parquetCREATE OR REPLACE TABLE FEATURE_OMNI_063 ASSELECT *FROM read_parquet("C:\Users\ASUS\Downloads\device.parquet")
DB SQL Executor
duckdb memory
ALTER TABLE FEATURE_OMNI_063ADD COLUMN IF NOT EXISTS DAY_ID VARCHAR;ALTER TABLE FEATURE_OMNI_063ADD COLUMN IF NOT EXISTS TYPE INT;UPDATE FEATURE_OMNI_063SET DAY_ID = strftime(current_date, '%Y-%m-%d');
DB SQL Executor
Merge db, map model sản phẩm với phân khúc
DB Merger
Tạo lại connection DB
DB Connection Extractor
copyFEATURE_OMNI_063to '/Users/toannk986/abb/temp/_tmp/FEATURE_OMNI_063_$${Sd_yyyymmdd}$$.parquet'
DB SQL Executor
GroupBy
GroupBy
DB Query Reader
ALTER TABLE FEATURE_OMNI_063DROP COLUMN FEATURE_OMNI_0841;
DB SQL Executor
String to Number
Table Creator
DB SQL Executor
Excel Writer
Tạo lại connection DB
DB Connection Extractor
dim_date v2
Tạo lại connection DB
DB Connection Extractor
Tạo bảng FEATURE_OMNI_0842_LOOKUP
DB Writer

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: admin
Created at: 2026-06-04
On NodePit since: 2026-06-09
Last update: 2026-06-30
Created with KNIME version: v5.11.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!