After this step, by using Column expression I want to set logic like where value > 0 it will be called “Upward” or else “Downward”.
My issue whether I would required to do it for 57 times… or is there any other short way round.
you can use Column Expressions node in example provided by @HansS but need to modify node’s configuration. Also for your use case you can use Rule Engine node.
Additionally you can use Unpivoting node to have values from all columns in one column. Then use one of above mentioned nodes to apply your logic and then use Pivoting node to get your original columns back.
Note: Moved this into new topic as it is not related to topic where you posted it.