Row value to String

[Brain]

Hello,
Here is my issue.
CheaderR.xlsx (8.3 KB)

I want to transform numerical values within horizontal rows. In this example, after using “UNPIVOT and PIVOT,” I get this file. I want the values 2 to become BON and 3 MOYEN.
Is it possible ?
Thanks
Br

[gonhaddock]

Hello @Brain
Depending the size of your task, few different solutions can be applied. If you have to replace a long list of categories; a workflow with reference table for replacements can deployed.

If your task is as simple as your excel example. You can go ahead with two consecutive ‘Rule Engine’ nodes, each one configured to replace an $EQUS_n$ column:

EQUS_1 Replacements:

// 
$Column Header$ LIKE "Note" AND $EQUS_1$ LIKE "2" => "BON"
$Column Header$ LIKE "Note" AND $EQUS_1$ LIKE "3" => "MOYEN"
TRUE => $EQUS_1$

EQUS_2 Replacements:

// 
$Column Header$ LIKE "Note" AND $EQUS_2$ LIKE "2" => "BON"
$Column Header$ LIKE "Note" AND $EQUS_2$ LIKE "3" => "MOYEN"
TRUE => $EQUS_2$

Note: this nomenclature is for string formatted columns; in case the original format is numeric, then replace LIKE “2” with ‘= 2’

BR

[Brain]

Absolutely perfect.
Many Thanks
Br