Replace a Row entry with a other Row entry

[Massi1]

Hey Alteryx Community, 

one Question. 

I have a many document numbers as a row and then i have multiple cost centers as colums. 

If the document number is booked under a cost center there is a 0 and if not there is a NULL. 

Now i must replace the entry of a row with a other entrie like if I have two 0 in a row and one of the row is over Cost center 600 than i must Replace the entry with the Cost number under 600.  Like This

document number	Cost center 100	Cost center 200	Cost center 600
515151	0	Null	0

Now i the row 515151 under Colum Cost Center 600 the 0 must replace with "Cost Center 100" 

Thanks! 

[wwatson]

could you give an example of the before data with maybe 4 or 5 rows and and example of how you want it to look afterwards?

That will help us provide appropriate guidance

[Massi1]

So the first Table is my Situation now. 

If I have 0 in CostCenters over 600. I must replace the 0 with CC who the other 0 is! 

IF theres only one 0 and thats in CC over 600 than change the 0 to NULL, If theres a 0 in CC under 600 then change nothing. 

Account	CC 100	CC 101	CC 102	C200	CC300	CC400	CC600	CC610	CC620	CC630
1222222	0	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	NULL
2323232	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL
5555555	0	NULL	NULL	NULL	NULL	NULL	0	NULL	NULL	NULL
6666666	NULL	NULL	NULL	NULL	NULL	0	NULL	NULL	0	NULL
7777777	NULL	NULL	NULL	NULL	0	0	NULL	NULL	NULL	NULL
8888888	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	0
Account	CC 100	CC 101	CC 102	C200	CC300	CC400	CC600	CC610	CC620	CC630
1222222	0	NULL	NULL	NULL	NULL	NULL	NULL	CC100	NULL	NULL
2323232	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL
5555555	0	NULL	NULL	NULL	NULL	NULL	CC100	NULL	NULL	NULL
6666666	NULL	NULL	NULL	NULL	NULL	0	NULL	NULL	CC400	NULL
7777777	NULL	NULL	NULL	NULL	0	0	NULL	NULL	NULL	NULL
8888888	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	CC102

[wwatson]

You could try something like this

[Massi1]

Thanks for the Reply, 

I think its a good idea. But I Add some elseIF because in the really data i Have some more Cost Centers. And then I get a error like the operator == is not gilty. 

Can you help me? 

Because in the formula its only = but never ==

[wwatson]

make sure you only have text columns included. The error could be because you've included the first column in the multi field tool and it is a numeric field

[Massi1]

Sorry my friend, 

but i only included only text datas. the Account number is not included. So i Dont really know what the problem is. 

[wwatson]

can you private message me the full formula you have now and I can take a look?

[wwatson · Accepted solution]

@Massi1 did you get it working?