Hub
Pricing About
WorkflowWorkflow

Challenge 13 - Onsite and Online Transactions - Solution

JustknimeitJustknimeit-13String processingRegular expressionsMedium
+2
knime profile image
Draft Latest edits on 
Mar 4, 2024 11:15 PM
Drag & drop
Like
Download workflow
Workflow preview
Onsite and Online Transactions Your company keeps data related to online and onsite transactions in a tabular dataset with the following format: Index Online Onsite 1 A.6777-01 2 7736-01 3 L-2210341175-00-000020 4 L-3210341175-00-000020 5 F5454 6 B_7736-01-00-000020 7 F5454 7736-01 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 onsite transaction 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 string from the online transaction. What is the most efficient way to perform this task? For the example above, you should produce the following output column: Product Codes 677701 773601 221034117500 221034117500 F5454 773601 773601
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.2.1
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.1.0

    knime profile image
    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.1.0

    knime profile image
    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.1.0

    knime profile image
    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits