Creating "One-To-Many" style of table

KNIME Analytics Platform
#1

I have several tables that I need to work through. Most of them are really large and need to be bit mapped out based on their value. In order to help import them into a dimension table, I need boolean or int tables that are 1/0.
An example will better describe
The possibilities are in json currently, in a 2 column table with a “ID”.

How they are now:
ID: Value
1: [“Alpha”,“Bravo”]
2: [“Alpha”,“Charlie”]
3: [“Charlie”,“Delta”]

What I want to do:
ID: Alpha | Bravo | Charlie | Delta
1: 1 1 0 0
2: 1 0 1 0
3: 0 0 1 0

I have done it with some string manipulations, however i needed to generate each case. This next upcoming issue may have 50-60 columns and doing manual comparisons just wont work. I have messed with the one to many by doing a JSON to Table -> One to Many, but it generates like Alpha_1 Alpha_2 etc.

Thanks

#2

Hi,

See attached workflow, hope it helps !

Martin K.

Alpha_Bravo.knwf (11.2 KB)

3 Likes
#3

That is fantastic. I was goofing around with a lot of the manipulation tools, and expected this to be very complicated. That was stupid simple. Thanks!

#4

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