Two columns in one or one column dynamically renamed

KNIME Analytics Platform
1

Hi I need some help in my work sometimes it happens to have to replicate some parts of wkf I was thinking about some components made as Templates, I need a hand, as you can see in the image my problem is that in the table part the field to search is sometimes on two columns and sometimes on just one and they never have the same column name. I’ll give you an example sometimes I have two columns with the following names FISCALE_CODE and PARTITA_IVA_CODE other times CODICE_FISCALE and PARTITA_IVA and usually either they are both valued in the same way or sometimes one is valued and the other is null while when there is it on only one maybe I only know CODICE_FISCALE. My question is is there a way with some node inside the component to be able to join them into a single one with another name when there are two and when there is one make a copy and make everything unique?

component
component1142×662 60 KB

Thank you

2

hey there,

I have to admit that I cannot really follow what issue you are running into.

Can you provide more specific information - e.g. which of your nodes is causing the issue. An example in excel would also be helpful to understand which table structures you are encountering and how you’d like to have that transformed…

5 Likes
3

How about this approach:

  • apply “empty column filter” to remove the column without any results
  • use regex renaming of the column containing “FISCALE” to a generic name

image

  • do the same for partitia
2 Likes