50 fields in CSV file to change...

KNIME Analytics Platform
1

Hi !

I have a file with more than 50 fields. Each field can have 4 values (1,2,3,4) and I want to transform these values in 25,50,75,100 (which is %). How can I easily change them with simplicity without testing every field ?

Thanks a lot.

Miky

2

Use the Normaliser node, specifing to limit the range to Min-Max of 1 to 100.

 

Simon.

3

Hi Simon.

Sorry, I was not really exact. I want :

100 for 1

75 for 2

25 for 3

0 for 4

Is it possible ?

Thanks a lot.

Miky

 

4

That's not really percent... but anyway, maybe not most elegant, but it could work with:

"Rule Engine" node

column1 is the column with your values. You can then either replace the column or append a new one.

// enter ordered set of rules, e.g.:
// $double column name$ > 5.0 => "large"
// $string column name$ LIKE "*blue*" => "small and blue"
// TRUE => "default outcome"
$column1$ = 1 => 100
$column1$ = 2 => 75
$column1$ = 3 => 25
$column1$ = 4 => 0

5

Hi,

Would have done something like in the workflow in attachment.

Best regards

Fabien.

6

It's work perfectly !!!

Thanks a lot !

Miky

7