How to replace the value

Question

NumberAccountAmountCategory100000645245082106.68 10000064568121000-8.887090781000006462450821033.85 100000646245082104.28 1000006462450821024.00 1000006462450821064.46 1000006462450821048.13 10000064624508210677.32 10000064664015000-48.1370600210000064665031000-33.8570953610000064665080000-24.0070953610000064666010000-677.3270600210000064666020000-4.2870961910000064666020000-31.5670961910000064666020000-64.46709619

If "number" is the same and "account" is not equal 24508210 and the number of row is one, replace value of “Amount” to value of “Amount” of account=24508210.

Such us: from

NumberAccountAmountCategory100000645245082106.68 10000064568121000-8.88709078

to

NumberAccountAmountCategory100000645245082106.68 100000645681210006.68709078

phoebe_90 · Answer

I want to use the '"Number" to locate the relation between “Account”. And to select the object which I want to change the value.

If "number" is the same and "account" is not equal 24508210 and the number of row is one.

Such us:

Meet the criteria.

NumberAccountAmountCategory100000645245082106.68 10000064568121000-8.88709078

Fail to meet the criteria.

NumberAccountAmountCategory1000006462450821033.85 10000064664015000-48.1370600210000064665031000-33.8570953610000064665080000-24.00709536

And then replace value of “Amount” to value of “Amount” of account=24508210.

Such us: from

NumberAccountAmountCategory100000645245082106.68 10000064568121000-8.88709078

to

NumberAccountAmountCategory100000645245082106.68 100000645681210006.68709078

FrederikE · Answer

Hey @phoebe_90,

I am not entirely sure what you want. Do you want to replace the amount within one number with the first amount of that number when the conditions are met?

Or are we really only talking about replacing everything with the Amount in the first row?

binu_acs · Answer

@phoebe_90 One way of doing it with the Multi-Row tool

Multi_Row_240323.yxmd