I am a new KNIME user attempting to create a workflow to translate a certain data source for a number of purposes. One key aspect of this data source is that each instance contains a number of tag variables, with each such column named Tagged<something>. However, the number of tags in each data set from the source varies, and I'd prefer not to have to re-hard code this each time.
Mainly, I need to 1.) recode the tag variables from 'x' and missing to 1 and 0, and from string to number, and 2.) At some point, convert wide to long with date, another variable, and each tag variables defining the new observations.
I've tried the Extract Column Header > etc. > TableRow to Variable Loop Start method for the first task, but that just appends rather replaces, leaving me with further problems to deal with.
Thanks in advance for any help anyone can provide!