Icon

02. Data Blending

Data Reading Activity: Data Manipulation & Aggregation Activity I- Concatenate web activity data from old and new systems. Get data for sentiment analysis Activity II- Join all data together using a series of Joiner nodes by the "Customer Key" field.- Clean up and document your workflow using annotations, node labels and metanodes.- Create a wrapped metanode and save it as template. Exclude Sentiment Ratingand Web ActivityWeb activity(old system)Demographics and History from SAS fileSentiment Analysis Web Activity (Old)First Web Activityfrom New Web SystemWeb Activity (New)Read Product DataNode 242 Column Filter Column Rename File Reader Table Reader File Reader Database Reader(legacy) SQLite Connector(legacy) Excel Reader (XLS) Concatenate join on customer Data Reading Activity: Data Manipulation & Aggregation Activity I- Concatenate web activity data from old and new systems. Get data for sentiment analysis Activity II- Join all data together using a series of Joiner nodes by the "Customer Key" field.- Clean up and document your workflow using annotations, node labels and metanodes.- Create a wrapped metanode and save it as template. Exclude Sentiment Ratingand Web ActivityWeb activity(old system)Demographics and History from SAS fileSentiment Analysis Web Activity (Old)First Web Activityfrom New Web SystemWeb Activity (New)Read Product DataNode 242 Column Filter Column Rename File Reader Table Reader File Reader Database Reader(legacy) SQLite Connector(legacy) Excel Reader (XLS) Concatenate join on customer

Nodes

Extensions

Links