Lookup and match cell value with top row's column value

Hi,
I want to look for the cell value that i have in every single row and match it with the top row(named Column Header), and if there’s a match, I want to write 1 in that particular row,column where row is the row number of my current row and column is the matching column that i found. For example, in the below picture, fl is in Row1 Column 0 but after my working, it should end up in Row 1 Column 12.

1 Like

Hi there @uzair118,

Welcome to KNIME Community Forum!

Don’t quite understand what are you trying to accomplish. To avoid guessing can you provide small input and expected output and logic if not clear from data? This is proven to be the best approach to get help/advice/solution :wink:

Br,
Ivan

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