Transfer data based on column name

[Gambit]

Hi Guys,

I need your help regarding this. I have this csv templates and some csv input files. I need to import both and transfer the data of the csv input files to the template based on the column names on the csv templates. Hope you can help me with this. Thanks in advance.

Regards,
Gambit

[izaychik63]

It looks like regular joiner has to work for you. Use datetime field as joining criterion.

[Gambit]

Hi @izaychik63,

Thanks for the advice. But the data is referencing on the column name of the template. The image I posted is just an example but the concept is the same.
Thank you.

Regards,
Gambit

[mlauber71]

Most likely a combination of joins and reference row filters would do. Often it is best to provide a minimal example that fully represents your challenge.

Reproducible (Minimal) Workflow Example

Hi there KNIMErs! What is this topic about? This topic is about helping yourself and KNIME community! How? By creating and sharing workflow examples that help and can be successfully ran by others When? When logic requires it. For example when you are opening a topic in order to get help (you are getting error or can’t configure node and would like someone else to take a look what is wrong; or you started a workflow and got stuck so need help with next step), when you are reporting …

[morpheus]

Hi @Gambit,
think about

1. reading data
2. unpivoting
3. inner join with template columns
4. pivoting results
5. exporting results

without example data i can’t provide an example workflow but probably this are the main steps you need.

BR

[Gambit]

Hi @mlauber71

Thanks for the advice. I will try to make dummy input data so I can show my concern.

Best regards,
Gambit

[Gambit]

Hi @morpheus

This is a good idea. Thank you! But what if the number and name of columns of the csv input data are changing? I will try to make dummy input data so I can show my concern. But the scenario is this: The CSV template has many column names that are not always existing on the CSV Input data. Same as the CSV input data, it has many column names that are not always existing on the CSV template data. For example, i have CSV Template 1 with Column Names A, B, C, D and E. On my CSV template 2, it has column names F, G, H and I. Then i have CSV input data with column names A, C, D. CSV input data 2 with B and e only. CSV input data 3 with column names F, H and I. What I want to accomplish is, the input will be able to go to the right CSV template where it’s column names are also existing. Please note that column names on the templates will not change and it will retain what are the column names existing in it.

Thanks in advance guys!

Best regards,
Gambit

[Gambit]

Hi @izaychik63,

Thanks for the comment

Best regards,
Gambit

[morpheus]

Hi @Gambit,

you can look also the other way around. That means, if you know your Data columns you can look for the corresponding template for which the column matches. Hence you have to read all your templates up front and bring them together in a table.

BR