Icon

jKi-13

jKi-13
Index Online Onsite1 A.6777-012 7736-013 L-2210341175-00-0000204 L-3210341175-00-0000205 F54546 B_7736-01-00-0000207 F5454 7736-01In this challenge, you are asked to extract digits from the transactions(which are related to the bought products) given the followingguidelines: (1) if the onsite transaction starts with “L”, then take its first12 digits; otherwise, take its first 6 digits; and (2) if the onsitetransaction has a missing value, then take the string from the onlinetransaction.What is the most efficient way to perform this task? For the exampleabove, you should produce the following output column:Product Codes677701773601221034117500221034117500F5454773601773601 Node 1Node 2Node 6Node 8 Table Creator Cell SplitterBy Position String Manipulation(Multi Column) Column Expressions Index Online Onsite1 A.6777-012 7736-013 L-2210341175-00-0000204 L-3210341175-00-0000205 F54546 B_7736-01-00-0000207 F5454 7736-01In this challenge, you are asked to extract digits from the transactions(which are related to the bought products) given the followingguidelines: (1) if the onsite transaction starts with “L”, then take its first12 digits; otherwise, take its first 6 digits; and (2) if the onsitetransaction has a missing value, then take the string from the onlinetransaction.What is the most efficient way to perform this task? For the exampleabove, you should produce the following output column:Product Codes677701773601221034117500221034117500F5454773601773601 Node 1Node 2Node 6Node 8 Table Creator Cell SplitterBy Position String Manipulation(Multi Column) 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: franz
Created at: 2022-04-23
On NodePit since: 2022-04-23
Last update: 2024-04-28
Created with KNIME version: v4.5.2
Tags: #justknimeit

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

Try NodePit Runner!