Replace columns with new columns with the same header

[mgarciat_upo]

Dear all,

I have a dataset with many columns (50). The values of some of these columns have been fixed. Is there any way to replace, in the dataset, such columns? The new columns have the same header than the ones presented in the table. Thank you in advance.

Best regards,

[ArjenEX]

Hi @mgarciat_upo

Can you include an example showing your current input (preferable in a workable format like a workflow) and expected output?

[mgarciat_upo]

Dear ArjenEX:

Attached to this post you an find the KNIME workflow with the data. I would like to find a way to do this process automatically. Thank you.

Best regards,
MiguelGT
Example-Replace_columns.knwf (88.6 KB)

[ArjenEX]

If I understand your use case properly, what you can do is filter out any ASV column from the main file by using a wildcard selection.

Then use a joiner based on the ID column and retrieve all the new ASV columns.

New output:

[mgarciat_upo]

Thank you very much!