Replace a Row entry with a other Row entry

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!

Workflow

Tips and Tricks

Common Use Cases

Best Practices

Transformation

API

Bug

Tableau

MongoDB

Machine Learning

Power BI

Accepted answers

wwatson

@Massi1 did you get it working?

All comments

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

multi field formula.yxmd

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

image.png

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

@Massi1 did you get it working?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703