List of the variables in a table

[AsaM]

Hi,
I am working with a complex dataset. Just to make my question simplified imagine a table of content like this below:

this is my question
How can I get a list of the content of this table like A,B,C,G,… and give a code 1/0 for each row

I’d appreciate any tips.

[Daniel_Weikert]

If possible upload the excel demo file instead of an image. Makes it easier for people to help
br

[AsaM]

Sure,
Here is the original table:

	Y	YI	YII	YIII
X	A		B
XI		C		B
XII	B		C
XII		A	C	B

And I would like to convert it to this table:

	A	B	C
X	1	1
XI			1
XII		1	1
XII	1	1	1

[HeatherPikairos]

Hi @AsaM

Please take a look at this example workflow that I have shared previously on the hub:

20230516 Pikairos Convert Object Categories Into Binary Fingerprints –...

Using the nodes up to the -RowID- node and changing the configurations to match your data should work:

I’ll share a workflow with your data when ready.

Edit: Here is the workflow for your example data:

20230523 Pikairos Convert Matrix into Binary Fingerprints – heatherpikairos

Thanks
Heather

[AsaM]

Thank you so much Heather for the workflow, it has worked perfectly.
|

[denisfi]

Hi @AsaM ,

If you just need to convert letters into numbers/bolean, just use the string manipulation multi columns and use it to change it.

Example:

I’ll replace the string value for number 1.

If I have missing values, i’ll say that it is empty one (string).

Result:

KNIME_project_listvariables.knwf (6.9 KB)

Thats it!

BR,

Denis

[HeatherPikairos]

No problem @AsaM If you are happy with my solution, I’d really appreciate it if you’d be able to the solution box for my reply that contains the shared the workflows
Thanks
Heather

[AsaM]

Already done, thanks

[HeatherPikairos]

Thanks a lot @AsaM