Value Re-Map

Value Re-Map: This is an Interactive View operated component for user friendly manual re-mapping of column values.

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 Data Folder: "data/iCFO_component_log_files" and then are broken out into individual 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 may be necessary. There is now a 1 time function to open the current log file folder for viewing and easy access.

Run the component to populate the workflow columns before opening the Configuration window on first installation or after an update.

V2 Changes:
Several of the Column Name assignments have been moved from the Interactive View over to the Configuration Window for better settings retention after updates and reduced clutter. Existing workflow Re-Map Headers log files are listed as well as the folder address for quick copy and paste access to the log files. Several error avoidances, speed optimizations, user feedback mesages and clearer descriptions were added. Custom CSS was added for a better layout and a more compact table layout for the Column / Header name Re-Map settings. The default number of columns per page is now 100 with an additional Apply Settings button at the bottom, as I prefer working with a wider visibility of Column Names now that there is a more compact table layout.

Options

Target Column Selection for Input Value List
Enter Description
Column Selection - Replacement Value List to provide Re-Map Select Dropdowns
Enter Description
How Many Rows per Page in Header Re-Map Table? (10-500)
Enter Description
Log Files Folder Location + List of Header Re-Map Log Files in Workflow
Enter Description
Remove Re-Map Value From List If Used?
Enter Description
Filter Out Unassigned Values
Enter Description
Sort Output Columns to Re-Map List Order? (Non Re-Mapped Columns Last)
Enter Description

Input Ports

Icon
Input Table
Icon
Table with Value List

Output Ports

Icon
Re-Mapped Table Out
Icon
Summary of Changes

Nodes

Extensions

Links