Header Re-Map (deprecated)

***This is an older version which uses a shared log folder approach. It required manual changes to log files when mulitple components were used in the same workflow to avoid syncing settings.*** The newer versions of my components self locate their specific parent component folder and create and save logs into component specific log folders.

Header Re-Map (deprecated): This is an Interactive View operated component for user friendly manual re-mapping of headers. Blocks double assignment of new header names, restricts dropdowns to unused values on refresh, includes 3 optional filters 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.

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.

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

Column Selection - Essential to Append (Yes / No value list) - Append + Restriction must be activated above...
Enter Description
Column Selection - Input Column Names Pre-Map / Backup Recovery (1 run only to populate - then return to (**No Pre-Map Column**) for manual changes)
Enter Description
Column Selection - Filter#3 for Re-Map Select Dropdown (Do not assign the same column to mulitple filters)
Enter Description
Column Selection - Filter#2 for Re-Map Select Dropdown (Do not assign the same column to mulitple filters)
Enter Description
Column Selection - Replacement Header List to provide Re-Map Select Dropdowns (The new column names are expected in a vertical list. "Transpose" if necessary)
Enter Description
Column Selection - Filter#1 for Re-Map Select Dropdown (Do not assign the same column to mulitple filters)
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
Append Unassigned Headers? (Appending a large number of headers impacts performance. I prefer to turn this on after Re-Mapping is complete)
Enter Description
Sort Output Columns to Re-Map List Order? (Non Re-Mapped Columns Last)
Enter Description
Restrict Append Essential Columns Only? (Must select column name containing Yes / No values below) - Append must be activated above...
Enter Description
Re-Map Log File Address --- format example:"just-the-name" --- ****DO NOT CHANGE FILE INFO OR DELETE WITHOUT BACKUP FIRST*** (If component is used more than once in same workflow, be sure to change default file name to avoid overwriting)
Do not include an extension. The file format ".table" will be added by component.

Input Ports

Icon
Input Table with wrong Headers
Icon
Input Table with New Header List / Backup

Output Ports

Icon
Re-Mapped Table Out
Icon
Output with Backup / Portable Re-map info

Nodes

Extensions

Links