i would like to know how to do a transformation like the following:
Attribute1 | Attribute2 |
and should be transformed to
Attribute1 | Attribute2 | A | B | C |
A C 1 0 0
C B 0 0 1
B B 0 1 0
Is there a Node for this?
thanks in Advance
we don’t have a special node doing this kind of transformation.
To simulate this behaviour use the following steps.
- Unpivoting. turn your two columnedtable into a kind of one column
- One2Many: Generate binary columns out of your newly created “combined” column
- GroupBy: Now group your rows again, using the old rowkey, using the maximum, for each binary column
(If you only have one column, instead of two to transform, you can do this without step 1 and 3, and only with step 2)
i tried it, and it had worked thanks for the answer. now i can create assoc rules from this : )
thx alot for ur help.