SOLVED
Transpose rows into columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AlterIT
8 - Asteroid
05-18-2021
01:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a dataset with few dimensions and I am trying to transpose some of the rows into columns.. Each User ID may have an Acct # in System A or System B or in Both. I need to transpose these Acct #s so that they will be represented as Sys A Acct # and Sys B Acct# . Also wanted 2 Boolean fields which says whether User ID has entry in Sys A or Sys B.
Tried few options with transpose and cross tab and could not get to work.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
2 REPLIES 2
phottovy
13 - Pulsar
05-18-2021
01:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AlterIT I recommend treating the systems and account numbers as two different calculations. The attached workflow gets the desired result but it could probably use some dynamic column renaming.
KarolinaRoza
11 - Bolide
05-18-2021
01:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator