Can't seem to get this to fly. Trying to condense some columns..

[Brad1]

I need to get this:

Record_Id	Ntwk_A	Ntwk_B	Ntwk_C
1	X
2		X
3			X

to look like this:

Record_Id	Network_Id
1	Ntwk_A
2	Ntwk_B
3	Ntwk_C

Surely, there is a simple way..  Thanks in advance.

[patrick_digan]

@Brad1 Try using a formula tool and using the max function:

Max(Ntwk_A,Ntwk_B,Ntwk_C)

EDIT: It helps if I read your post first :)  Try using a transpose, group by record_ID, and then a filter to get rid of the nulls.

[MarqueeCrew · Accepted solution]

@Brad1,

You can use a transpose tool, a filter and a crosstab to get you there....

[JohnJPS]

HI @Brad1,

Would the attached workflow work? Transpose and filter out the nulls?

Thanks,

John

[Edit: Wow, @patrick_digan and @MarqueeCrew are fast.]

[Brad1]

Maybe I'm not using the formula tool correctly.  Just upgraded to 11.0 today.  That formula gives me this:

Record_Id	Ntwk_A	Ntwk_B
1	X	X
2	X	X
3	X	X

Just putting 2 Networks in the formula (to see what would happen) and not even filtering for anything besides Ntwk_A.

I'm sure I'm probably using the tool wrong.

[MarqueeCrew]

Please do try my workflow....

[Joe_Mako]

Another potential route, if the fields are constant:

- Multi-Field Formula to replace non empty with Field Name
- Formula to Coalesce the values
- Select to remove the extra fields

[Brad1]

I've been trying it for awhile with no luck.  Still trying..

[Brad1]

I did get it to work.  My issue was I clicked on either the transpose or cross tab tool b4 running.  doing that caused errors.  So I started tampering with it when I should have just hit play.  Thanks very much for your help.

[Brad1]

Thanks Joe.  I'm going to pull this down as well and see where we can put it to use.