Transformation

Hii,
I wanna a do following transformation in my data: assume I have 2 columns A and B , I have to convert the entries of column B to 1 if the corresponding value of column A lies in highest 20% values of entire column.
which node will be helpful for this …please explain

Hi @06mickey

You can use the AutoBinner in combination with a RuleEngine node, to do the job.
transform_top20.knwf (84.3 KB) .
Screenshot from 2020-07-19 22-39-20
gr. Hans

4 Likes

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