Hub
Pricing About
ComponentComponent

Header Re-Map

icfo profile image
Draft Latest edits on 
Aug 2, 2023 7:34 PM
Drag & drop
Like
Use or download
Header Re-Map V5: This is an Interactive View operated component for user friendly manual re-mapping of headers. It can be run in (Basic Mode) - Horizontal Headers or (Advanced Mode) - Vertical Header List (This allows for support columns for additional filtering / append options). The dropdown selection blocks locks double assignment of new header names, restricts dropdowns to unused values on refresh, includes 3 optional filters (Advanced Mode) to better manage a large number of dropdown header values (filters have a bypass option in the interactive view, defaulting to bypasss), includes option to append any unassigned new columns, includes option to sort new columns to match the list order (with old fields remaining in front), also includes backup and recovery or pre-mapping. It also now includes Show / Hide Settings to show only changes, without changes, or the full list. I also added a single run Backup / Recovery function to save and return to a save point. The update button handles all saving and updating. Simply close the window and discard changes after each use. If this component is used more than once in the same workflow, be sure to enter different log names in the configuration window unless you want their re-map settings to remain linked. You can view the updated output and review the column data to help with mapping via the Node Monitor after hitting "Apply Re-Map" in the component. If you have a dual monitor setup, then I recommend placing the component interactive view on a separate monitor from the workflow. This ensures that the component window doesn't fall behind KNIME AP, and allows for more visibility of the data and output via the Node Monitor. ***Do not open multiple versions of the same window, as it can cause conflict errors if the settings are mismatched*** In the event that this happens, it is only a minor inconvenience as you simply need to manually close all of the interactive view windows for the component via the taskbar. Log Files / Backup Files are kept in the Relative Folder Path "data/iCFO_component_log_files" under thier component ID subfolders. ****If this component is nested within another component or metanode, a manual copy and paste of the logfiles to the new component address will be necessary.**** The prior log files will remain in their folder under the old component ID. Run the component to populate the workflow columns before opening the Configuration window on first installation or after an update, and run the component after changing the Basic / Advanced mode settings to show / hide additional settings.

Component details

Input ports
  1. Type: Table
    Table Input
    Input Table with wrong Headers
  2. Type: Table
    Header Input
    Input Table with New Header List / Backup
Output ports
  1. Type: Table
    Re-mapped Table
    Re-Mapped Table Out
  2. Type: Table
    Backup Info
    Output with Backup / Portable Re-map info

Used extensions & nodes

Created with KNIME Analytics Platform version 4.7.6 Note: Not all extensions may be displayed.
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.6

    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.3

    knime
  • Go to item
    KNIME JavaScript ViewsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.4

    knime

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, 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