Can't seem to get this to fly. Trying to condense some columns..
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI @Brad1,
Would the attached workflow work? Transpose and filter out the nulls?
Thanks,
John
[Edit: Wow, @patrick_digan and @MarqueeCrew are fast.]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please do try my workflow....
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I've been trying it for awhile with no luck. Still trying..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Joe. I'm going to pull this down as well and see where we can put it to use.
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)