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.
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.