Filtering columns with matching headers

KNIME Extensions
1

Hi Everybody,

 

I have the following problem:

 

I got a table A with about 100 different column headers and another table B with about 600 different table headers. Now I need something like the functionality of the reference column filter:

So I need just the columns of table B which also exists in table A. The fact is that not the whole column should be the same but just the columns with the same header.

To make it clear...

examle:

Table A:

A B C D E F G H I J K L M N O
0 0 0 1 1 1 0 0 0 1 1 1 0 0 0
0 0 1 1 0 0 1 1 0 0 1 1 0 0 1
0 0 1 0 1 0 1 0 1 0 1 0 1 0 1
1 1 1 1 0 0 1 1 0 0 1 1 0 0 1

Table B:

A G Z X F P G H Y S T L M V U
0 0 0 1 1 1 0 0 0 1 1 1 0 0 0
0 0 1 1 0 0 1 1 0 0 1 1 0 0 1
0 0 1 0 1 0 1 0 1 0 1 0 1 0 1
1 1 1 1 0 0 1 1 0 0 1 1 0 0 1

 

result:

A G F G H L M
0 0 1 0 0 1 0
0 0 0 1 1 1 0
0 0 1 1 0 0 1
1 1 0 1 1 1 0

 

Can anybody help me?

 

Cheers,

 

Vanessa

2

Hi Vanessa,

The Reference Column Filter node should do exactly what you want to do. It only filters by column name, not by the values of the columns.

Best,

Roland

3

Hi

just use the reference column filter node in Manipulations -> Column -> Filter -> Reference Column Filter

 

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.