I have an extensive internal generic column name approach that I utilize for most of my clients. This has a ton of benefits on the back end, but it often requires re-mapping 100+ column names when patching into new DB structures. At this point I am using an Excel conditional dropdown approach to align input columns for generic renaming, but I would love to hear if others are using KNIME tools for friendly UI on tasks along these lines. I would especially be interested if anyone has pulled off something like an interactive table editor along these lines. Maybe something like the generic column names being uneditable / static, but the values in the other input column can be moved to align for name re-mapping?

I had to delete and re-upload my shared component and workflow due to some strange hub issues. The component now has dummy data in it which makes it infinitely easier to edit. [image] Header Re-map – icfo Solutions for data science: find workflows, nodes and components, and collaborate in spaces. [image] Header Re-Map – icfo This is an Interactive View operated component for user friendly manual re-mapping of headers. Blocks double assignment of new header names, restricts dropdown… I recently realized that this general approach to building user friendly tools for data manipulation also holds the potential for me to build front end app style interfaces for end users to write back changes to the underlying data directly in KNIME AP / KNIME Server.

friendly UI tricks for re-mapping column names?

KNIME Analytics Platform

ipazin January 9, 2023, 7:18am 3

Hello @iCFO,

sounds like something similar to request in this topic:

You’ll find workflow example in it which probably needs some improvement in order to work for you.

Br,
Ivan

3 Likes