Icon

XIII - Onsite and Online Transaction

There has been no description set for this workflow's metadata.

Points to remember:My own work - Smallest # of nodes used Problem Statement:Your company keeps data related to online and onsite transactions in a tabular dataset with the following format:In this challenge, you are asked to extract digits from the transactions (which are related to the bought products) given the following guidelines: (1) if the onsitetransaction starts with “L”, then take its first 12 digits; otherwise, take its first 6 digits; and (2) if the onsite transaction has a missing value, then take the stringfrom the online transaction.What is the most efficient way to perform this task? For the example above, you should produce the following output column: My Learning:Nodes: Column Expression ( IF else) Node 2Node 4 Table Creator Column Expressions Points to remember:My own work - Smallest # of nodes used Problem Statement:Your company keeps data related to online and onsite transactions in a tabular dataset with the following format:In this challenge, you are asked to extract digits from the transactions (which are related to the bought products) given the following guidelines: (1) if the onsitetransaction starts with “L”, then take its first 12 digits; otherwise, take its first 6 digits; and (2) if the onsite transaction has a missing value, then take the stringfrom the online transaction.What is the most efficient way to perform this task? For the example above, you should produce the following output column: My Learning:Nodes: Column Expression ( IF else) Node 2Node 4 Table Creator Column Expressions

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: aparajitapallav
Created at: 2022-12-30
On NodePit since: 2022-12-30
Last update: 2024-11-21
Created with KNIME version: v4.6.3
Tags: JUSTKNIMEIT-13

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

Try NodePit Runner!