I have some options fake that have an specific character based on its header. This header normally is repeated. I would like to align characters based on the header name as shown in the following images:
Hi @plati , so it would depend on the values of the first row? It makes things definitely more complicated for sure.
Also, now I’m not guaranteed that the first row would have a record in all the columns, as opposed to if there was a header, Knime would make sure there is a header even if there was not one, so there should be an additional check for this now.
Probably a Transpose and a Group By and Transpose back could work, I’d have to try it to see (I don’t have time at the moment to build a workflow unfortunately).